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
- 75177 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
wat wil hapn if we give the both read and deny read permission to user?
how to use DTS package in 2000,2005,2008 in sql server
Is it possible to have clustered index on separate drive from original table location?
Is sql different from sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
Can you use order by when defining a view?
Difference between group by clause and having clause in SQL?
What is query and its types?
What are the commands used in DCL?
What is the difference between clustered and a non-clustered index?
What is the maximum size of a row in sql server?
plss anybody specify tha constrian management system in dbms
What is always encrypted?
Explain indexed views?
how would you improve etl (extract, transform, load) throughput?
