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 cursors in ms sql server?

1154

Is mysql better than sql server?

1045

What is repeatable read?

988

How to delete an existing database user?

1000

What are types of subqueries?

1039

What is the syntax to execute the sys.dm_db_missing_index_details?

1000

When does a workload on SQL Azure get throttled?

129

How would you choose between a clustered and a non-clustered index?

950

What is the difference between varchar and nvarchar datatypes?

1069

Describe in brief sql server monitoring ways.

1035

Define self join in sql server joins?

935

Define cursor locking

983

What is the use of sql profiler in sql server 2012?

873

How do you create an execution plan?

926

List the types of recovery model available in sql server?

915