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 are the steps to take to improve performance of a poor performing query? : sql server database administration
What happens if we shrink log file in sql server?
Explain what are the events recorded in a transaction log?
What is the difference between TRUNCATE and DROP?
How to write character string constants or literals in ms sql server?
What is trigger and different types of Triggers?
What is the usage of the sign function?
What are the differences between left join and inner join in sql server?
Explain system functions or built-in functions? What are different types of system functions?
What is the stored procedure?
What is subreport?
what are the core components of SSRS?
What are the advantages of log shipping?
Can sql servers link to other servers?
Explain database normalization?