write the query for find the top 2 highest salary in sql
server
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 de-normalization and what are some of the examples of it?
What is #table in sql server?
What is difference between global temporary tables and local temporary tables?
How to loop through result set objects using mssql_fetch_array()?
Explain how would you store your query in an SSRS report or a Database server?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How to find the list of fixed hard drive and free space on server?
What are the rendering extensions of ssrs?
Explain what are the restrictions while creating batches in sql server?
What is it unwise to create wide clustered index keys?
How to create user messages with print statements in ms sql server?
How to create hyperlink from returned sql query ?
What is an identity?
Explain user defined functions?
Difference between Inner vs outer joins?