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 key set driven?
What the different components in replication and what is their use?
What are the different acid properties?
Explain various On-Delete options in a DB table. Which is the default option?
Tell me what is log shipping?
Mention the differences between having and where clause.
How many joins in sql server?
What are the difference between clustered and a non-clustered index?
What is difference between count (*) and count 1?
What are the requirements for sql server 2016?
How to create a Master database in SQL server ?
How to create stored procedures with parameters in ms sql server?
What is collation sensitivity? Explain different types.
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is the command used to check locks in microsoft sql server?