select * from emp as e1 where 1= (select count(*)from emp as e2 where e1.

I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000

Question Posted / bhagya

17 Answers
20944 Views
HCL, IBM, I also Faced
E-Mail Answers

Answer Posted / bhagya

select * from emp as e1 where 1= (select count(*)from emp
as e2 where e1.sal<e2.sal)

Is This Answer Correct ?

9 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between a function and a trigger?

1060

Explain difference between control flow and data flow?

943

How to test values returned by a subquery with the in operator?

1175

List out different types of normalizations in sql server and explain each of them?

914

What is the Difference Between Primary and Foreign Key?

985

What is the Control Flow in SSIS

1073

What are indexes in sql?

1245

Write a SQL command to insert and update only a particular field?

1087

What does set rowcount do?

887

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1359

What is 1nf 2nf?

993

How to assign null values to variables or columns?

955

How to copy the tables, schema and views from one sql server to another?

1027

What are the difference between primary keys and foreign keys?

952

How to drop an existing user defined function in ms sql server?

1014