SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM employee OR

how to retrive only second row from table in sql server
2000?

Question Posted / belson gnana pradeep

Answer Posted / belson gnana pradeep

SELECT TOP 1 salary FROM
(SELECT DISTINCT TOP 2 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can sql server instances be hidden?

983

What is the difference between SQL notification and SQL invalidation?

1197

Do you know what are the properties of the relational tables?

1032

What is a natural primary key?

1054

Define left outer join in sql server joins?

970

How many types of local tables are there in sql server?

934

What is a dbms wizard?

1026

What are trace flags?

1037

Explain a differential backup?

1014

How do I find the sql server database version?

1015

What are the diifferences between the ms sql server vs mysql?

1179

What are the lambda triggers?

916

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

Tell me what is difference between clustered and non clustered index?

946

What are the two authentication modes in sql server?

1126