[Solved] SQL Query to fetch salary and distinct no of employees geting that sal from emp table [closed]

by

[ad_1]

select
emp.Salary, COUNT(*)
from
emp
GROUP BY
emp.Salary

Will return a distinct list of Salaries and the number of Employees who have that salary, provided that Salary and Employee are both contained on a communal table (can’t tell from the question wording).

Try expanding your question a little to get a better response.

1

[ad_2]

solved SQL Query to fetch salary and distinct no of employees geting that sal from emp table [closed]