select top 1 * from (select top 5 * from customers order by salary desc) a

Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?

Question Posted / vsandhyana

14 Answers
20424 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / vsandhyana

select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc

Thanks
Vikram Sandhyana

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are all types of Batches?

980

-----------With out using DrillThrough how to do Reports?

1990

How to create a cube in Transformer? What is the process? Please mention process thank u

1702

Can you define a datastore in cognos?

977

Can you define materialized view?

989

What are the advantages of using cognos sql?

1126

What junk dimension contains?

940

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2006

What is the enterprise class platform architecture of cognos 8?

972

What is the use of report studio?

978

Can you define fan trap?

1224

what is requery in cognos?

2447

How is cognos model organization works?

1007

What is the difference between a cascading report and drill through the report?

1115

what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

2458