select e.* from (select row_number() over (order by salary desc) as Rno,*

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / naufal basheer

Answer Posted / naufal basheer

select e.* from
(select row_number() over (order by salary desc) as Rno,*
from employee)e
where e.Rno = 2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the exact numeric data type in sql?

1005

Comment,Datatypes are unlimited

2068

what is bit datatype? : Sql server database administration

924

Write a SQL queries on Self Join and Inner Join.

1050

Define msdb database?

1033

Explain Capacity planning to create a database? and how to monitor it?

4207

What is the use of tempdb? What values does it hold?

1075

What are the different types of join?

1176

What is difference between sql and sql server?

1009

In which sql server version report builder introduced?

150

How to apply cascading referential integrity in place of triggers?

1038

What is a self join in sql server?

1141

What do you understand by the analysis services in sql server?

946

What’s the use of custom fields in report?

945

What are Spatial data types in SQL Server 2008

1026