Answer / amruta dash

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

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);

Answer / rajkumar v

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

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 )

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);

Answer / m.s.patil

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

27777 is max salary in table

Answer / sannnnnnnnnnn

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

Answer / raja

select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by 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;

Answer / sandeep rana

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

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

Explain Trigger with an example?

2 Answers  

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

When would you use the stored procedures or functions?

0 Answers  

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

Where is trigger in sql server?

0 Answers  

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

What is an identity?

0 Answers  

How do you test your database? : sql server database administration

0 Answers