To find second largest salary in Employee table
Answer Posted / anil
select max(salary) from tbl_employee where salay <(select max(salary) from tbl_employee)
| Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
What is the syntax to execute the sys.dm_db_missing_index_details?
What are the basic features of a trigger in ms sql server?
Explain unique key in sql server?
Delete duplicate rows without using rowid.
What programming language would you use to create embedded functions in ssrs?
What is SQL Azure Firewall?
Difference between report and query parameter.
Tell me what do you understand by a view? What does the with check option clause for a view do?
How do I uninstall sql server 2014?
What is a self join in sql server?
What is the difference between join and inner join?
What are the advantages of stored procedure in sql server?
What are the key configuration files for sql server reporting services ?
How do you troubleshoot errors in a SQL Server Agent Job?
Explain atomicity?