write the query for find the top 2 highest salary in sql
server
Answer Posted / krishna
select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)
| Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
What is named query? : sql server analysis services, ssas
What are views in ms sql server?
What is isnull() operator?
What is resource governor in sql server?
Do you know the capabilities of cursors?
What new data source types were added in ssrs 2014?
Does the order of columns in update statements matter?
What are exact numeric data types in ms sql server?
Where are sql server usernames and passwords stored in the sql server?
Where are stored procedures in sql server?
What is acid mean in sql server?
What is reference section?
What is 2nf normalization?
What is 'write-ahead log' in sql server 2000 ?
What is difference between unique and primary key?