write the query for find the top 2 highest salary in sql
server
Answer Posted / vijayalaxmi m khot
select max(sal) from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Can we join two tables without primary key?
What is sql service broker?
what data regions are and what are the different data regions?
When columns are added to existing tables, what do they initially contain?
How to return the second 5 rows in ms sql server?
Explain steps of normalization?
What is self contained scalar sub query?
What do you do in data exploration
what authentication modes does sql server support? : Sql server database administration
What is nested transaction?
Mention the different types of triggers?
How to connect to SQL Azure Database by using sqlcmd?
What is the difference between a view and a stored procedure?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What are the differences between stored procedure and view in sql server?