2. Second highest salary from the table select top 1 salary from emp whe

1. How to fetch all the duplicate records from the table.

2. How to fetch the second highest salary from the table.

Question Posted / ashwini

Answer Posted / ashwini

2. Second highest salary from the table

select top 1 salary from emp where salary NOT IN
(SELECT MAX(salary) FROM emp)order by salary desc

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a view using data from another view?

938

Do you know what are acid properties?

1052

Is sql server free?

893

How many types of objects are there?

984

What is difference in performance between insert top (n) into table and using top with insert?

1019

What are system databases in ms sql server?

1024

Explain what is the difference between a local and a global temporary table?

979

Define outer join in sql server joins?

922

how you can move data or databases between servers and databases in sql server? : Sql server administration

947

What is the rdl file?

138

How much space does sql server 2016 take?

939

Explain isolation levels that sql server supports?

1023

What is the difference function and stored procedure?

1030

What is the bookmark lookup and rid lookup?

982

When should you use an instead of trigger?

944