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
- 12903 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / nasa
select *from emp where sal in(select max(sal) from emp where level<=10 connect by prior sal>sal group by level);
This query show the top 10 records based on the salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
----------------------What are the User Securities?
What do you understand by the term 'dynamic cube'?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
whats the difference between previous version of cognos and cognos 8 BI?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Can you define report item?
Can you define cognos powerplay?
What are all the types of gateway used in Cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What are shortcuts? Where it can be used? What are the advantages?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is cognos connection?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What are the different types of reports present in cognos?
