Multiple choice technology databases

What is true for following DML SQL statement SELECT username, exp, salary FROM r4r_team ORDER BY username DESC;

  1. Used to select username,exp, salary from r4r_team which is decreasing order by username.

  2. Used to select username,exp, salary from r4r_team which is increasing order by username.

  3. Used to select username,exp, salary from r4r_team which is decreasing order by exp.

  4. none
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ORDER BY username DESC sorts in decreasing (descending) order by username, not increasing order and not by the exp column. DESC = highest to lowest, DESC only applies to username, not to exp.

Keep practicing — related questions