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
Is a primary key unique?
How to create new table with "create table" statements?
when you create a database how is it stored? : Sql server database administration
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Define right outer join in sql server joins?
Is sql server implemented as a service or an application? : Sql server database administration
Explain what is raid and what are different types of raid levels?
Explain about builtinadministrator?
What is an index in sql?
Explain Geography datatype in SQL Server
What is normalization? Describe its different types.
How to provide column names in insert statements in ms sql server?
What are temporal tables in sql server 2016?
Write down the syntax and an example for create, rename and delete index?
How to choose all records from the table?