write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 69280 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / pari
select max(sal) from emp
where sal !=(select max(sal) from emp);
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the difference between a fill factor of 100 and 0?
How efficient you are in oracle and SQL server?
What types of Joins are possible with Sql Server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is Cross Join and in which scenario do we use Cross Join?
If user is owning any SQL Objects, can we drop that user
What are the advantages dts has over bcp?
How can delete duplicate records in cte in sql server?
What is difference between group by and having?
What the different types of Replication and why are they used?
What is create command?
What is the process of normalising?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Explain what are the different index configurations a table can have?
