write the query for find the top 2 highest salary in sql
server
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 |
Post New Answer View All Answers
What is Sqlpaging in SqlServer 2005 ?
Do you know the isolation level that sql server support?
What are unicode character string data types in ms sql server?
What are the new data types are introduced in sql 2000?
Explain system rowset functions?
How to automatically create a log when an exception is being received into SQL Server?
Difference between DELETE and TRUNCATE?
What is the difference between an index and a unique index?
Explain the stored procedure?
Can group functions be used in the order by clause in ms sql server?
What is tabulation?
What is onf in normalization form?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is read uncmmited?