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
- 74150 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / uday
select * from Emp e where 1=(select count(Distinct
d.esal)from emp d where d.esal>e.esal)
i am sure that it should work.
Any thing wrong plz inform me
| Is This Answer Correct ? | 5 Yes | 9 No |
Post New Answer View All Answers
What does null mean?
What kind of problems occurs if we do not implement proper locking strategy?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
how many no of arguments can be passed in procedures and functions
What are cascading parameters in ssrs reports?
what is the system function to get current user's user id? : Sql server database administration
When multiple after triggers are attached to sql table, how to control the order of execution?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is the difference between locking and multi-versioning?
Which sql server table is used to hold the stored procedure scripts?
What is DCL?
What are translations and its use? : sql server analysis services, ssas
What is application role in sql server database security? : sql server security
What is a derived table?
How do I create a stored procedure in dbml?
