SELECT TOP 1 id.salary FROM (SELECT TOP 2 id,salary FROM employee

I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000

Question Posted / radhakrishnan vaithilingam

17 Answers
21152 Views
HCL, IBM, I also Faced
E-Mail Answers

Answer Posted / radhakrishnan vaithilingam

SELECT TOP 1 id.salary
FROM (SELECT TOP 2 id,salary
FROM employee
ORDER BY salary DESC )a
ORDER BY a.salary ASC

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to modify the underlying query of an existing view?

991

what is package and it uses and how can u call a package

2015

Is sql server a database?

1003

Difference between aggregate functions of sql?

1107

Explain mixed authentication mode of sql server?

1067

What is a matrix in ssrs?

153

What are the differences between substr and charindex in sql server.

1118

How do I open port 1433?

933

Can we use trigger new in before insert?

925

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1751

Is sql different from sql server?

1094

What is merge statement?

1084

Explain about SQL server 2005?

983

How many partitions a clustered index has by default in sql server 2012?

1089

Mention the uses of stored procedures.

973