Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 20888 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / balanandam
select * from emp where sal =(select sal from(select sal,rank() over(order by sal desc) sal_rank from emp group by sal) where sal_rank=&rank)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by drill across?
What is the size of database for you project?
what is a prompt value in report studio and variables ?
what are the special features in cognos reportnet?
What is dtm?
What is the deployment requirements used in cognos?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
is cognos 7 is better than cognos 8
Tell me about Dnamic and Static Dashboards?
How to Reset Pagenumbers in one report.
what are slowly changing dimensions? Why we are used scd?
what is catalog and types of catalogs in cagnos and which is better?
how u will design the report if the objects are available
What do you understand by the cognos?
Why is auto-regression used in forecasting used on cognos platform?
