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
desc.
| Is This Answer Correct ? | 13 Yes | 14 No |
Post New Answer View All Answers
Differentiate sql server reporting services vs. Crystal reports?
What are the advantages of using third-party tools?
What is a database in ms sql server?
Explain about system database?
Explain indexed views?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to use go command in "sqlcmd"?
Is the primary key column of a table an index in ms sql server?
Sql server reporting services vs. Crystal reports.
What is single-user mode?
Which tcl commands are available on the sql server?
What are triggers in ms sql server?
What is an sql server agent?
What is sql server transaction log file?
What are scheduled tasks in sql server?