How to get top 5 salary data in sql query

Hi It will definatly work:

select  * from employee where salary in (select distinct top 5 salary from employee order by salary desc)

SELECT TOP 5 WITH TIES Name, Salary FROM tlevel ORDER BY Salary desc

with Result as
(
   select dense_rank () over (order by salary) as 'TopSalary',* from table name
) select * from Result where TopSalary between 1 and 5

hi

SELECT DISTINCT TOP 5 salary
FROM employee
ORDER BY salary DESC

solution 2 is correct write like solution 2

as per Solution 2

SELECT *
FROM table
WHERE
(
 salary IN
 (
  SELECT TOP (5) salary
  FROM table as table1
  GROUP BY sal
  ORDER BY sal DESC
 )
)

Try this:
Make Inner Join on your subquery with desired salary span.

SELECT * FROM yourTable AS T1
INNER JOIN 
(SELECT DISTINCT TOP 5 Salary FROM yourTable ORDER BY Salary DESC) AS T2
ON T1.Salary = T2.Salary 

ORDER BY Salary DESC

SELECT TOP 5 salary
FROM employee
ORDER BY salary DESC

SELECT * FROM tablename WHERE Salary in(SELECT TOp 5 Salary from tablename GROUP BY Salary ORDER BY DESC)

Please follow the link.. try to search in google if you dont get your answer then post in CP

How to get top 5 salary data in sql query[^]

Say Employe table contains emp_id, salary, rank, dept_id as columns and has some data in it.

1. To get max salary from Employee table.

SELECT MAX(salary) FROM employee;

2. To get max salary from Employee table with respect to dept.

SELECT MAX(slary), dept_id from employee group by dept_id;

3. To get top 5 salary

select distinct salary from employee order by salary desc limit 5;

4. To get top 5 salary with respect to dept

select distinct salary, dept_id from employee order by salary desc limit 5;

5. To get 2nd max salary

select max(salary) from employee where salary not in(select max(salary) from employee);

5. To get 2nd max salary with respect to department

select max(salary), dept_id from employee where salary not in(select max(salary) from employee) group by dept_id;

Hope, this will give better idea on queries to get max number and with respect to other field.

Suppose if you have rank in column and would like you to find rank, then make sure use MIN in place of MAX.

Cheers....

select * from employees e1
where (select count (distinct salary) from employees e2
where e2.salary>= e1.salary) between 1 and 5 order by salary desc;