select top 2(salary) from emp_sal where salary in (select sal from emp

please tell me the query to get details of the employee
having the second largest salary

Question Posted / ravikiran

Answer Posted / ravikiran

select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is ms sql server service broker?

1048

What gets stored inside msdb database?

1309

What is acid properties?

1193

What is difference between rownum and row_number?

1025

What is purpose of normalization?

1001

How to list all triggers in the database with sys.triggers in ms sql server?

1139

How to create dbo table in sql server?

1009

How to choose all records from the table?

1110

What is Federation and Federation Member?

How to deploy the Report?

140

What is triggers and its types?

1070

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2054

Is it possible to call a stored procedure within a stored procedure?

1030

Write a SQL query in order to merge two different columns into single column?

1089

Mention the differences between sql server and mysql.

1087