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 the truncate command?

982

what is bit datatype? : Sql server database administration

916

What is amo? : sql server analysis services, ssas

1089

What is the benefit of normalization?

1080

What is dbcc? Give few examples.

1033

Can you import Microsoft Excel data to SSRS?

132

Name few endpoints exposed by ssrs 2012?

355

What are the various editions of sql server 2017 that are available in the market?

890

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1029

How to invoke a trigger on demand?

1092

What is use of except clause? How it differs from not in clause?

1019

Explain full-text indexing?

980

What is dimension table? : sql server analysis services, ssas

1018

What is the use of commit?

999

what is the difference between delete table and truncate table commands? : Sql server database administration

1033