View the Exhibit and examine the structure of the PRODUCTS table. You want to display only those product names with their list prices where the list price is at least double the minimum price. The…

Question

Options

• AORDER BY prod_list_price DESC, prod_name;
• BORDER BY (2*prod_min_price)DESC, prod_name;
• CORDER BY prod_name, (2*prod_min_price)DESC;
• DORDER BY prod_name DESC, prod_list_price DESC;
• EORDER BY prod_list_price DESC, prod_name DESC;

• A
  83% (29)
• B
  3% (1)
• C
  3% (1)
• D
  11% (4)

Explanation

Using the ORDER BY Clause The order of rows that are returned in a query result is undefined. The ORDER BY clause can be used to sort the rows. However, if you use the ORDER BY clause, it must be the last clause of the SQL statement. Further, you can specify an expression, an alias, or a column position as the sort condition. [WHERE condition(s)] [ORDER BY {column, expr, numeric_position} [ASC|DESC]]; ORDER BY specifies the order in which the retrieved rows are displayed ASC orders the rows in ascending order (This is the default order.) DESC orders the rows in descending order If the ORDER BY clause is not used, the sort order is undefined, and the Oracle server may not fetch rows in the same order for the same query twice. Use the ORDER BY clause to display the rows in a specific order. Note: Use the keywords NULLS FIRST or NULLS LAST to specify whether returned rows containing null values should appear first or last in the ordering sequence.

No community discussion yet for this question.