write the query for find the top 2 highest salary in sql
server
Answer Posted / santosh kumar
select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.
Is This Answer Correct ? | 11 Yes | 12 No |
Post New Answer View All Answers
How many primary keys are possible in a table?
What is a database table?
Why transaction is important?
Is natural join and equi join same?
What are different types of join?
What happens if an integer is too big for int date type?
What are the different types of normalization?
What is nested transaction?
What is dynamic cursor in SQL SERVER?
How to insert stored procedure result into temporary table?
How to stop a loop early with break statements in ms sql server?
What are drillthrough reports?
What are exact numeric data types in ms sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Give an example of SQL injection attack ?