write the query for find the top 2 highest salary in sql
server
Answer Posted / neeraj sharma
select ename,sal from emp where rownum<=3 order by sal desc
Note:- every table has rownum column but it is hidden by
default you can see it by this
select rownum from your_table_name
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is the data tier application?
Explain time data type in sal server 2008?
Tell me what is use of except clause? How it differs from not in clause?
What is the importance of three tier architecture?
Explain about nested stored procedure?
How to execute a sql statement using odbc_exec()?
How to create a dml trigger using create trigger statements?
What is the query and subquery?
What is subreport?
Explain error and transaction handling in sql server?
what is a join and explain different types of joins? : Sql server database administration
What is the difference between local and global temporary tables?
Why we need sql server?
Can the query output be sorted by multiple columns in ms sql server?
Write an SQL query to obtain the 2nd highest salary.