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
- 20418 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / srcreddy
select* from
(select rownum rank,ename,sal from emp order by sal desc) where rank=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
WHAT ARE THE DISTNICT VARIABLES?
What is the use of cognos decision stream?
What is the deployment requirements used in cognos?
What are the considerations regarding performance kept in mind while setting up cognos?
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?
What is meant by drill down?
Explain the different types of views used in cognos.
What is cognos powerhouse?
What is difference between primary key and unique key constraints?
What is a Folder?
Can you define cognos impromptu?
What is a Transformer?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
Can you define cognos decision stream?
what is the difference between querystudio in reportnet and cognos8
