write the query for find the top 2 highest salary in sql
server
Answer Posted / vijayalaxmi m khot
select max(sal) from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to concatenate two character strings together?
Write an sql query to find first weekday of the month?
How to access the deleted record of an event?
What are scalar functions?
What are cursors in ms sql server?
How can I get data from a database on another server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
How to fine-tune reports?
How will you monitor replication latency in transactional replication? : sql server replication
What is dknf in normalization form?
What is self contained multi valued query?
What do you mean by tablesample?
which table keeps the locking information? : Sql server administration
What are a scheduled jobs or what is a scheduled tasks?
List out the differences between the clustered index and non-clustered index in sql server?