examine the two sql statements given below select lastname salary hiredate..., MySQL, 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 
D None of the statments is correct

/71

+ AnswerA

+ Report

Descriptive on MySQL Ebook

Total Preview: 3895

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

D None of the statments is correct

A

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?