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

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

What type of database is cloud sql?

0 Answers  

What is mutating error in pl sql?

0 Answers  

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

what is meant by forward declaration in functions?

4 Answers   TCS,

What is sql basics?

0 Answers  

Can you join a table to itself?

0 Answers  

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

What is the left table in sql?

0 Answers  

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

what is a join? : Sql dba

0 Answers