Answer Posted / sandeep rana
select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How you trouble shoot when any job fails
Can group by and orderby be used together?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How to update a field in SQL after ALTERING a row?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
How to delete a database in ms sql server?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the difference between inner join and equi join?
What is normalization 1nf 2nf 3nf?
Tell about MOM Tool(Microsoft Operator Manager)?
what stored procedure would you use to view lock information? : Sql server administration
Can we do dml on views?
Why we use the openxml clause?
What is difference between count (*) and count column?
Indexes are updated automatically is the full-text index also updated automatically?