select empname,salary from( select empname,salary, rank() over( order by

To find second largest salary in Employee table

Question Posted / sujith

Answer Posted / sujith

select empname,salary from(
select empname,salary, rank() over( order by salary desc) ss from emp)
where ss=2;

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain index in sql server?

1021

How to find the second highest salary of an employee?

1183

What are transactions in sql?

1069

What are the new features of sql server 2008 r2 reporting service?

209

Where the sql logs gets stored?

992

What is key set driven?

963

Is BCNF better than 2NF & 3NF? Why?

1052

Explain having clause?

972

Explain in details security in SQL azure?

121

what is the difference between a primary key and a unique key? : Sql server database administration

1010

how to trace the traffic hitting a sql server? : Sql server database administration

1885

Explain the difference between cross join and full outer join?

984

What are the different types of Indexes available in SQL Server?

1010

Difference between connected and disconnected database in .net with sql server?

1104

What are the advantages of log shipping?

998