Is there an important difference on why the emp_no was chosen instead of salary? As far as I know, I'm getting the same results as your solution, I'm just wondering if there is something I'm missing. Code I used: USE employees; SELECT salary, COUNT(salary) AS emps_with_same_salary FROM salaries WHERE salary > 80000 GROUP BY salary ORDER BY salary DESC;

Hi Louis! Thanks for reaching out. You can use this column as well. Since the columns have the same length and do not contain NULL values the result set will be the same. Hope this helps. Best, Tsvetelin

Follow this topic

Louis Tanghal

Last answered:

19 Jul 2022

Posted on:

16 Jul 2022

COUNT(salary) vs COUNT(emp_no)

in SQL / Using Aliases (AS)

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Posted on:

19 Jul 2022

COUNT(salary) vs COUNT(emp_no)

Submit an answer

related questions