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

Describe different Processing Modes offered by SSRS?

256

How do I save a stored procedure in sql server?

1054

Explain cursor as data base object?

1099

What are commonly used mssql functions in php?

1145

What is 'write-ahead log' in sql server 2000 ?

1108

What is meant by Active-Passive and Active-Active clustering setup?

1274

What is subquery explain with example?

1124

How to filter records of table in SQL SERVER?

1134

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1174

Call by value and call by reference in procedure and function, with NOCOPY.

1351

Explain how you can deploy an SSRS report?

156

how can a database be repaired? : Sql server administration

1018

What is normalization? What number of normalization shapes are there?

1161

Is the primary key column of a table an index in ms sql server?

1005

What are the different types of sub-queries?

1091