-- USING MS SQL SERVER SELECT TOP 1 FROM ( SELECT DISTINCT TOP 2 FROM

How to read 2nd highest sal from EMP table?

Question Posted / b.kumar

Answer Posted / b.kumar

-- USING MS SQL SERVER

SELECT TOP 1 FROM

( SELECT DISTINCT TOP 2 FROM EMP ORDER BY SAL DESC) EMP
ORDER BY SAL ASC

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the full form of dql?

972

What is conditional split?

1044

What are tables in sql server?

1008

How to use subqueries with the exists operators in ms sql server?

1100

Introduction of rollup clause using sum and group by clause?

938

Give the query of getting last two records from the table in SQL SERVER?

928

What are trace files?

935

How can I create a new template for import ? : sql server management studio

1056

How do I create a partition table in sql server?

1090

What are the 3 types of schema?

1087

What is sql service broker?

965

How to find table changes in sql server?

1096

How will you hide an attribute? : sql server analysis services, ssas

935

How to assign null values to variables or columns?

956

What are the different types of normalization?

1139