write the query for find the top 2 highest salary in sql
server
Answer Posted / santosh kumar
select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.
| Is This Answer Correct ? | 11 Yes | 12 No |
Post New Answer View All Answers
What are transactions in sql?
What is the difference between writing data to mirrored drives versus raid5 drives
What is postgresql server?
What is the difference between Normalization and De-normalization?
What is inner join? Explain with an example?
What are different types of statements that are supported by sql?
what is database replicaion? : Sql server database administration
What is a trace frag?
What is Command line parameters in PLSQL.?
What is explicit cursors?
What is the beast way to write CTE in SQL Server ?
What are the different types of upgrades that can be performed in sql server?
What is change data capture (cdc) feature?
How efficient you are in oracle and SQL server?
What is RAID? What are the different types of RAID configurations?