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

What is multi-statement table-value user-defined function?

938

What are the properties of the transaction?

968

What is a covered index?

893

What happens when transaction log is full?

873

Explain the difference between clustered and non-clustered index?

872

How to convert a table data in XML format in sql server?

2495

What is model database? : SQL Server Architecture

1062

What is the impact on other user sessions when creating indexes?

876

Where are full-text indexes stored?

948

What are triggers in ms sql server?

1105

Explain sql server authentication modes?

1077

What is sqlcmd?

963

What are Spatial data types in SQL Server 2008

968

What is oltp (online transaction processing)?

953

Do you know what are pages and extents? : SQL Server Architecture

944