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 does executeupdate return?

981

What is the difference between inner join and equi join?

1004

Explain stored procedure?

1060

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1808

Do you know what are the steps to process a single select statement?

978

Can multiple columns be used in sql group by clause in ms sql server?

1055

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1607

What are differences in between sql server 2012 and sql server 2016?

1053

What is isnull() operator?

1047

What are the advantages of user-defined functions over stored procedures in sql server?

1048

Where to find ntwdblib.dll version 2000.80.194.0?

962

What are the 2 types of classifications of constraints in the sql server?

1127

Does sql server use java?

1078

What is user defined stored procedures?

950

How many types of local tables are there in sql server?

934