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
- 12589 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
New coloums are added in database, then how you know in report level
write a query to display the departments with no employee?
what are the features in cognos8ui
What are shortcuts? Where it can be used? What are the advantages?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
how you create security to reports?
What is defined as Cognos Impromptu?
How do we convert from Numeric to be Words?
What is defined as catalog and types of catalogs in Cognos?
What is the difference between low affinity and high affinity connections?
How to Reset Pagenumbers in one report.
dumps needed ASAP for - C2020-180 Cognos IBM Certification
How to deploy from one server to another server?
What is difference between informatica power mart and power center?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
