Answer / vikas naik

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

Answer / chitti

Hi Viewers here is the simple query to find the highest
salary:-

1)Highest five salaries:-

select top 5 salary from employee order by salary desc

2)Highest 5th salary:-

select top 1 salary from(select top 5 salary from
employee order by salary desc) temp1 order by salary asc

3)Highest 4th salary:-

select top 1 salary from (select top 4 salary from
employee order by salary desc) temp1 order by salary asc

4)Highest 3rd salary:-

select top 1 salary from (select top 3 salary from
employee order by salary desc) temp1 order by salary asc

5)Highest 2nd salary:-

select top 1 salary from(select top 2 salary from
employee order by salary desc) temp1 order by salary asc

6)Highest 1st salary or highest salary:-

select max(salary) from employee

Answer / abhishek kundu

SELECT MAX(SALARY) FROM EMP
WHERE SALARY<(SELECT MAX(SALARY) FROM EXP);

Answer / chirag shah

select DISTINCT(salary) from emp order by salary desc limit 1,1

this limit gives you 2nd record
if you want 3rd value then write limit 3,1

Answer / prudhvi

select sal from emp a where 1=(select count(*) from emp b where a.sal>b.sal);

Try this guys,if u want highest sal use 0 in where condition, for second highest 1,third 2........

Answer / jithu

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)

Answer / subash pandey

SELECT salary
FROM employee e
WHERE n = (
SELECT count( * )
FROM employee
WHERE salary > e.salary )

n=1 or 2 or 3 n is level which level max salary you want
i test this it proper work

Answer / aravind naidu

select * from emp e where (select count(*) from emp where sal>=e.sal)=&n; put n = 2 for second highest sal,n = 3 for third highest sal ....and so on.

Answer / raju tt

select max(salary) from employees where salary not in
(select max(salary) from employees)

Answer / barochia dharmesh

select Income from (
select Rank() over(order by Income desc) topRecord, Income
from (select distinct Income from tblName) tbl ) tbl2
where topRecord = 2

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

what is the forward decleration in packages?

1 Answers  

What is offset in sql query?

0 Answers  

What is optimistic concurrency control? : Transact sql

0 Answers  

Can we insert in sql function?

0 Answers  

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

What is trigger and how to use it in sql?

0 Answers  

What is interval partition?

0 Answers  

What is clause?

0 Answers  

How many types of functions are there in sql?

0 Answers  

How to fetch alternate records from a table?

0 Answers