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

Explain nested trigger in sql?

1004

What are the basic features of a trigger in ms sql server?

1106

How do I find the port number for sql server?

919

Why do we need different type of parameter?

997

How to name query output columns in ms sql server?

915

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

962

What is RAID? What are the different types of RAID configurations?

1061

What is the difference between resultset and resultsetmetadata?

889

Can a table be moved to different filegroup?

917

What is replication with database mirroring? : sql server database administration

985

You want to implement the one-to-many relationship while designing tables. How would you do it?

910

what is memory-optimized nonclustered indexes

957

What are group functions in query statements in ms sql server?

945

How would you go about developing a ssrs report?

156

How to write a query with a full outer join in ms sql server?

998