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

To find second largest salary in Employee table

Question Posted / murugesh

17 Answers
20878 Views
CSS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between Datepart() and Datename() in SqlServer?

1264

Where in ms sql server is ’100’ equal to ‘0’?

1133

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1024

What action plan is preferred if sql server is not responding?

1159

What is the difference between the application object and session object?

1124

Define Business Edition in SQL Azure?

102

Explain what is lock escalation and what is its purpose?

986

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1659

How to list all objects in a given schema?

1109

What do you understand by triggers?

979

What is the use of RDBMS?

1056

How do I start sql server 2016?

954

How to use "begin ... End" statement structures in ms sql server?

1121

Explain powershell included in sql server 2008?

1117

What is rtm version in sql server?

1106