Consider an emp table having columns empno, empname, salary Which of the following queries sort emp table by empname and then by salary in descending order

  1. select empno, empname, salary from emp order by empname, salary desc;

  2. select empno from emp sort by empname, sal in desc;

  3. select empno, empname, salary from emp sort in empname, salary desc;

  4. select # from emp sort by empname and salary in desc;


Correct Option: A

Find more quizzes: