write the query for find the top 2 highest salary in sql
server
Answer Posted / kapil singh chauhan
select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is co-related sub query?
What do you understand by replication in sql server?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Can foreign key be deleted?
Describe and explain about SQL native client?
Write a code to select distinct records without using the DISTINCT keyword.
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How many tables can be joined in SQL Server?
What are the different authentication modes in sql server? How can it be changed?
How to delete database objects with "drop" statements in ms sql server?
What is rtm version in sql server?
What is the difference between ddl,dml and dcl commands?
Which database stores information about replication?
What do mean by xml datatype?
What is the use of toad or sqldbx.?