examine the two sql statements given below select lastname salary hiredate..., ANSI SQL, Databases

Test
- Model Test
Index

Question:Examine the two SQL statements given below:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
What is true about them?

A The two statements produce identical results 
B The second statement returns an error 
C There is no need to specify DESC because the results are sorted in descending order by default

/30

+ AnswerA

+ Report

Descriptive on ANSI SQL Ebook

Total Preview: 737

Question:Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is true about them?

A The two statements produce identical results

B The second statement returns an error

C There is no need to specify DESC because the results are sorted in descending order by default

A