Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 72797 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
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
Why are you getting errors when creating a new odbc dsn?
What is the difference between a function and a stored procedure?
What encryption security is available in sql azure?
Difference between report and query parameter.
what data regions are and what are the different data regions?
Find columns used in stored procedure?
Why do we partition data?
What is replace and stuff function in sql server?
What is difference between count (*) and count column?
What is the purpose of grouping data in a report?
What is transact-sql ddl trigger?
Explain what are the restrictions while creating batches in sql server?
Does server sql treat char as a variable-length or fixed-length column?
What is the purpose of floor function?
what is a schema in sql server 2005? : Sql server database administration
