how to find the second salary?

Answers were Sorted based on User's Feedback



how to find the second salary?..

Answer / amruta dash

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

Is This Answer Correct ?    23 Yes 1 No

how to find the second salary?..

Answer / vamsi krishna

For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);

Is This Answer Correct ?    14 Yes 3 No

how to find the second salary?..

Answer / rajkumar v

Select min(salary)FROM emp WHERE (salary IN (SELECT TOP 2
salary FROM emp ORDER BY salary DESC))

Is This Answer Correct ?    4 Yes 0 No

how to find the second salary?..

Answer / kavitha

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

or


select max(salary) from tablename where salary <(select
max(salary) from tablename )

Is This Answer Correct ?    3 Yes 0 No

how to find the second salary?..

Answer / vishnu

Here we can find out 2nd highest salary in many ways,
according to the situation we can select anyone…
1st Type:
select min(esal) from emp where esal in (select top 2 esal
from emp order by esal desc)

2nd Type:
select max(esal) from emp where esal not in(select max(esal)
from emp)

3rd Type:
select max(esal) from emp where esal <(select max(esal) from
emp )

4th Type:
select Max(esal) from EMP a where 2=(select
COUNT(distinct(esal)) from EMP b where a.eSAL<=b.eSAL);

Is This Answer Correct ?    3 Yes 0 No

how to find the second salary?..

Answer / m.s.patil

select max(sal) from t1 where sal not in (27777);

27777 is max salary in table

Is This Answer Correct ?    3 Yes 1 No

how to find the second salary?..

Answer / sannnnnnnnnnn

select max(sal) from emp where sal<(select max(sal) from emp)

Is This Answer Correct ?    1 Yes 0 No

how to find the second salary?..

Answer / raja

select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by salary

Is This Answer Correct ?    2 Yes 2 No

how to find the second salary?..

Answer / moorthy t

select n,* from(select rownum n,* from (select * from table
where group by (sal) order by (sal) desc)) where n=2;

Is This Answer Correct ?    0 Yes 2 No

how to find the second salary?..

Answer / sandeep rana

select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More SQL Server Interview Questions

Is SET a SQL Keyword?

4 Answers   BitWise,


How to count the number of duplicate items in a table?

3 Answers  


What is ddl command?

0 Answers  


What is the sql case statement used for?

0 Answers  


What is @@Identity in sql?

1 Answers   Cap Gemini,






What is faster join or union?

0 Answers  


What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  


How do you create a data source?

0 Answers  


When would you prefer to have a minimum number of indexes?

0 Answers  


Explain about system stored procedure?

0 Answers  


how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,


What are locks in sql?

0 Answers  


Categories