> > >

MySQL MCQs

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?

The two statements produce identical results

The second statement returns an error

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

None of the above statments is correct

Answer

Correct Answer: The two statements produce identical results

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it