Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 2 Answers
- 5733 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / lakshmi reddy
top 10 records
select * from emp where rownum<=10
Based on maximum salary(hithest top 10 salaries with details)
select * from (select emp.* from emp order by sal desc)
where rownum<=10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is stitch query in reportnet?
What is a Cube?
4. How many dimensions did you use in your reports?
What are the advantages of shortcuts?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
faq's on cognos
What are products of cognos?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
What you mean by drill across and what is the difference between drill through, drill across?
What is the difference between a cascading report and drill through report?
New coloums are added in database, then how you know in report level
What is cognos powerhouse?
What is a Transformer?
Can you explain new content durability?
