select min(salary) from (select top 2 salary from phani order by salary de

write the query for find the top 2 highest salary in sql
server

Question Posted / mohan c v

Answer Posted / mohan c v

select min(salary) from
(select top 2 salary from phani order by salary desc) as a

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is Sqlpaging in SqlServer 2005 ?

1115

Do you know the isolation level that sql server support?

1003

What are unicode character string data types in ms sql server?

1344

What are the new data types are introduced in sql 2000?

949

Explain system rowset functions?

1045

How to automatically create a log when an exception is being received into SQL Server?

1359

Difference between DELETE and TRUNCATE?

1095

What is the difference between an index and a unique index?

1044

Explain the stored procedure?

1094

Can group functions be used in the order by clause in ms sql server?

1067

What is tabulation?

1012

What is onf in normalization form?

1111

Can I run multiple instances of sql server 2000 at the same time on one computer?

1120

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1078

What is read uncmmited?

1115