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 do you understand by pl/sql packages?

0 Answers  

what is not null constraint? : Sql dba

0 Answers  

how to drop an existing table in mysql? : Sql dba

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

Which command is used to delete a trigger?

0 Answers  

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

when normalization is required

3 Answers   HCL,

Types of optimization?

6 Answers   Microsoft,

Can we insert data into view?

0 Answers  

What are literals in sql server?

0 Answers  

Name the operator which is used in the query for pattern matching?

0 Answers  

What is dbo in sql?

0 Answers