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

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

Please Help Members By Posting Answers For Below Questions

New coloums are added in database, then how you know in report level

1549

What is model?

958

what is a prompt value in report studio and variables ?

2702

----------------Diff b/w Dimensional modeling and Relational modeling?

14984

What is the metric store database?

961

What do you mean by Drill down and Drill Up?

990

Can you define materialized view?

1041

how you migrate reports to cognos 8 from previous versions?

1034

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1918

What are slice and dice?

920

which type of project we r going to snowflake schema

1973

How can we create a dynamic column name in cognos?

947

What do you mean by query studio?

938

What is Fullouterjoin?

1967

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2015