Oracle
1Z0-061 · Question #262
The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8, 2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product_name; What is true…
The correct answer is D. The results are sorted numerically and then alphabetically. the result is sort by price which is numeric and follow by product_name which is alphabetically.
Restricting and Sorting Data
Question
The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8, 2) Evaluate this SQL statement:
SELECT * FROM PRODUCTS ORDER BY price, product_name; What is true about the SQL statement?
Options
- AThe results are not sorted.
- BThe results are sorted numerically.
- CThe results are sorted alphabetically.
- DThe results are sorted numerically and then alphabetically.
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C17% (4)
- D75% (18)
Explanation
the result is sort by price which is numeric and follow by product_name which is alphabetically.
Topics
#ORDER BY#multi-column sort#numeric sort#alphabetical sort
Community Discussion
No community discussion yet for this question.