To find second largest salary in Employee table
Answer Posted / satish
select salary from emp_Table_1 where 2= (select count(*)
form emp_Table_2 where emp_Table_2.salary < emp_Table_1.salary)
-satish
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to transfer an existing table from one schema to another schema in ms sql server?
What is an example of a foreign key?
Explain what is it unwise to create wide clustered index keys?
What are types of subqueries?
How can you insert values in multiple rows using one Insert statement?
what are different types of backups available in sql server? : Sql server database administration
How to edit table in sql server 2017?
Describe different Processing Modes offered by SSRS?
Explain about SQL server 2005?
How to transfer data from a cursor to variables with a "fetch" statement?
What command would you use to add a column to a table in sql server?
Why use triggers?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Write SQL queries on Self Join and Inner Join.
Write an sql query for deleting duplicate rows?