Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 8 Answers
- 13161 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rajasivam.p
To find nth value
select salary from emp a where &n=(select count(distinct
salary) from emp b where a.empno<=b.empno);
to find max by nth value a.empno<=b.empno
to find min by nth value a.empno>=b.empno
OR
To find 10 max records
select * from (select * from emp order by salary desc) where
rownum<=&n;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain what is the main advantage of impromptu over cognos reportnet?
What is called Cognos powerplay?
What is Metrics designer?
Can you define transformer?
What is the report studio?
What do you mean by drill across?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Can you define query studio?
What do you mean by query studio?
What is the difference between low affinity and high affinity connections?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
9. What was the most complex type of report you dealt with?
What is the difference between a cascading report and drill through the report?
Write various indexes used in cognos?
What are the two types of framework manager?
