Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Data Analyst
/
Easy
/
Sorting by two columns
easy
5 pts · first answer counts
sql
order-by
Sorting by two columns
How are the rows sorted by this query?
Choose one answer
A.
By salary high to low, then by department A–Z
B.
By department A–Z only; DESC is ignored
C.
By department A–Z; within each, highest salary first
D.
By department Z–A, and then by salary from high to low
Submit answer
Report a problem
← Previous
Column alias in WHERE fails
Next →
Window function vs GROUP BY
All easy Data Analyst questions
Discussion
0
Join free
to post in the discussion.
Related questions
WHERE vs HAVING
Data Analyst
Which join keeps all customers
Data Analyst
COUNT(*) vs COUNT(column)
Data Analyst
Finding NULL values
Data Analyst
COUNT(DISTINCT) with NULLs
Data Analyst
Rows from an INNER JOIN
Data Analyst
UNION vs UNION ALL
Data Analyst
AVG with a NULL value
Data Analyst
More SQL questions