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
What is the recovery model?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Explain the relational database management system (rdbms)?
What are the various editions of sql server 2017 that are available in the market?
what kind of lan types do you know? : Sql server database administration
Define clusters?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to test subquery results with the exists operator?
How do you Implement SSIS Packages in your Project?
What are the different type of replication in sql server?
What is a raid and what are different types of raid configurations?
How many types of functions are there in sql server?
How do I setup a local sql server database?
How to create a large table with random data for index testing in ms sql server?
Explain the architecture of ms sql reporting service?