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

What are the different normalization forms?

1118

How would you use user_constraints table in DB?

1008

What should be the fill factor for indexes created on tables? : sql server database administration

1142

How to receive output values from stored procedures?

1146

What is an example of a foreign key?

975

What do you understand by recursive stored procedure?

933

What are user-defined functions (udfs) in sql server?

993

Explain having clause?

972

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

906

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2021

What does executeupdate return?

981

What is the security principal at the server level that represents your session?

1014

Define a cross join?

1033

Is sql server a database?

1003

Explain how you can configure a running aggregate in SSRS?

163