select * from (select row_number over( order by salary desc) as salcount,

To find second largest salary in Employee table

Question Posted / murugesh

Answer Posted / murugesh

select * from (select row_number over( order by salary
desc) as salcount,empid,salary from employee) emp
where emp.salcount = 2

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What happens if the update subquery returns multiple rows in ms sql server?

1058

How to define output parameters in stored procedures?

961

What are scheduled tasks in sql server?

1011

Explain the xml support sql server extends?

985

Name the different type of indexes in sql?

909

Define a cross join?

955

Explain forward - only cursors?

986

What are the advantages of using third-party tools?

921

Using the customer, and order table in northwind database, please write a query to produce xml?

1009

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

918

Who is the owner of a schema in ms sql server?

1011

How to enter binary string literals in ms sql server?

1098

Can we deploy SSRS reports on our personal website?

162

What is the benefit of normalization?

1022

How do you Implement SSIS Packages in your Project?

1872