For Finding Nth Salary... SELECT TOP 1 Salary FROM (SELECT TOP nth Sala

write query for fourth maximum salary from employee table

Question Posted / dharmendra k. dixit

Answer Posted / dharmendra k. dixit

For Finding Nth Salary...

SELECT TOP 1 Salary FROM
(SELECT TOP nth Salary FROM Table Order by Salary Desc)Table
As Sal Order by Salary

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is difference between inner join and join?

1027

What are functions in the sql server?

1189

Tell me about normalization in DBMS.

984

What is the partitioning method?

1006

How do you make a trace?

1000

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1146

How to see existing views in ms sql server?

1022

Explain sql server service broker?

960

What is a result set object returned by mssql_query()?

1134

What is conditional split?

1046

What are the two modes of authentication in sql server?

1042

What is autocommit mode in sql server?

1147

How many joins in sql server?

931

What is the difference between a clustered index and a non-clustered index?

979

What is the difference between mysql and mysqli?

1171