select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal d

write a query for the fifth highest salary?

Question Posted / bhramar

Answer Posted / bhramar

select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain buffer manager?

991

What is the importance of database partitioning?

1100

how can you perform lookup range in lookup stage expalin in detail?

1974

Explain the record term used in database.

1115

What is a Transformation?

1067

After normalization, what are the conditions which have to keep in mind to de-normalize it?

1097

Why do we need distributed database?

1042

Is hive a database?

987

Differentiate between extension & intension?

1471

What advantages does DBMS have over traditional file systems?

1078

What is database schema name?

1097

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

2302

How much does it cost to build a database?

1071

What is the difference between oracle and MS Access?

1107

What is ole db in ssis?

1102