select Top 1 salary from emp_Table where salary in(select Top 2 Salary fr

To find second largest salary in Employee table

Question Posted / vikas kant

Answer Posted / vikas kant

select Top 1 salary from emp_Table where salary in(select
Top 2 Salary from emp_Table order by salary desc)

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a function and a stored procedure?

1004

How much space does sql server 2016 take?

908

How will you make an attribute not process? : sql server analysis services, ssas

1008

In how many ways you can invoke ssrs reports?

131

What is stored procedures?

954

What are the purposes of floor and sign functions?

921

When we should use and scope of @@identity?

951

between cast and convert which function would you prefer and why?

915

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

919

How to create a simple stored procedure in ms sql server?

973

how you can get the list of largest tables in a database? : Sql server administration

983

What are a scheduled jobs or what is a scheduled tasks?

847

How connect excel to sql server?

928

Can you index views?

850

How to enter date and time literals in ms sql server?

951