Question: Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name column list_price The list_price column discount_percent The
Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name column list_price The list_price column discount_percent The discount_percent column discount_amount A column thats calculated from the previous two columns discount_price A column thats calculated from the previous three columns Use the ROWNUM pseudo column so the result set contains only the first 5 rows. Sort the result set by discount price in descending sequence. In ORACLE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
