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
- 5635 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / harish
based on salary top 10 records for emp table
select * from ( select * from emp order by sal desc)where rownum<=10;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between the standard and metrics folder?
drillthrough vs master detaild report,which one is the best by performance?
How do you improve the performance of the Cognos Analytics report
What are all the types of gateway used in Cognos?
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
What are differences between Reporter report and Explorer report?
what is the difference between Cognos EP7 series and Congos8?
What r the names of the reports that you prepared?
tell me the creation of Snapshots?
How the Bursting happens in same report and how to Print the bursting Report?
----------------What is Surrogate Key?
How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..
Teradata 
