CREATE TABLE T1(SALARY int, [NAME] varchar(50)) SELECT TOP 1 SALARY FROM

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / preeti chauhan

Answer Posted / preeti chauhan

CREATE TABLE T1(SALARY int, [NAME] varchar(50))
SELECT TOP 1 SALARY FROM (SELECT TOP 2 SALARY FROM T1 ORDER
BY SALARY DESC)T1 ORDER BY SALARY

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to divide query output into multiple groups with the group by clause in ms sql server?

965

Explain system views?

1024

What is store procedure? How do they work?

956

How can we delete Duplicate row in table?

1000

Distinguish between commit and rollback?

901

what happens on checkpoint? : Sql server database administration

1021

Explain few examples of RDBMS?

977

What authentication modes does sql server support?

1023

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2668

What is query and its types?

875

What is stretch database in sql server?

1028

How would you add a section to a table?

970

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2160

What are rest-style architecture's?

170

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

953