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
- 20958 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
explain how to create powerplay reports?
Why cognos decision stream is used?
What is the difference between the content store and content manager?
What is difference between page break and section report?
what is the difference between native sql and cognos sql?
When we save a report in report studio with what extn it save?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
how to test reports in cognos?
What is the function of cognos dispatcher?
What are the different kinds of panes included in cognos?
Why need staging area database for dwh?
What is Metrics designer?
What r the names of the reports that you prepared?
Can you define a datastore in cognos?
How is possible this scenario using in type-in prompt.?
