To find second largest salary in Employee table
Answer Posted / vikas kant
select Top 1 salary from emp_Table where salary in(select
Top 2 Salary from emp_Table order by salary desc)
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What happens if you add a new index to large table?
What does asynchronous call backs means?
What is a performance monitor?
Do you know hot add cpu in sql server 2008?
What are exact numeric data types in ms sql server?
How to insert a new row into a table with "insert into" statements in ms sql server?
How can we delete Duplicate row in table?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are system databases in ms sql server?
What are the differences between sql server and mysql.
Do you know what are the restrictions that views have to follow?
Tell me about the approaches which you used to counter the DI problems.
Explain transaction server explicit transaction?
Characterize join and name diverse sorts of joins?
Explain filtered indexes?