select salary from emp_Table_1 where 2= (select count(*) form emp_Table

To find second largest salary in Employee table

Question Posted / satish

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

Please Help Members By Posting Answers For Below Questions

Where do you find the default Index fill factor and how to change it?

1111

What is dbcc command in sql server?

1149

What is the difference between dataadapter and datareader?

1055

What does it mean to invest in the index?

1019

What are the differences between web role and worker role?

124

How to find which stored procedure is currently running in sql server?

1041

How to change the data type of an existing column with "alter table" statements in ms sql server?

1034

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1131

How to connect to a sql server using odbc_connect()?

1201

How to use column default values in insert statements in ms sql server?

1097

How to add a new dsn with the odbc driver for sql server?

1112

Difference between connected and disconnected database in .net with sql server?

1147

What triggers long term care?

1084

What is the recovery model?

1055

what's the difference between a primary key and a unique key? : Sql server database administration

988