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)

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

Can we call stored procedure in view in sql server?

0 Answers  

Explain what is log shipping?

0 Answers  

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

What is service broker? : sql server database administration

0 Answers  

What is built-in function?

0 Answers  

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

Can you explain important index characteristics?

0 Answers