Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
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
New coloums are added in database, then how you know in report level
What is model?
what is a prompt value in report studio and variables ?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is the metric store database?
What do you mean by Drill down and Drill Up?
Can you define materialized view?
how you migrate reports to cognos 8 from previous versions?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What are slice and dice?
which type of project we r going to snowflake schema
How can we create a dynamic column name in cognos?
What do you mean by query studio?
What is Fullouterjoin?
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