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 views are stored in sql server?

991

Define Joins?

1035

How to create a trigger for insert only?

1045

Tell me what are the essential components of sql server service broker?

942

Explain database normalization?

1231

Can you explain powershell included in sql server 2008?

942

Is oracle faster than sql server?

957

Explain various data region available in ssrs with their use?

936

What is the report builder?

139

What do you understand by recursive stored procedure?

933

Are resultset updatable?

960

How to find the second highest salary of an employee?

1179

how can you check the level of fragmentation on a table? : Sql server administration

985

What are the requirements to use odbc connections in php scripts?

1121

What have included columns when we talk about sql server indexing?

1037