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 are cursors stored procedures and triggers?

1024

in the physical file layout, where should the transaction log be stored in relation to the data file?

998

What are the 10 characteristics of data quality?

962

Does index speed up select statements?

1017

What are the database objects? : SQL Server Architecture

1058

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514

What is a trace frag? Where do we use it?

1108

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1028

How to enter date and time literals in ms sql server?

1023

Do you know what are acid properties?

1088

Can we install sql server 2016 on windows 7?

1145

What is the difference between a check constraint and a rule?

1263

Do you think BCNF is better than 2NF & 3NF? Why?

1282

Do you know what is difference between index seek vs. Index scan?

959

What is model database in sql server?

1058