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
- 5612 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 surrogate key give example?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What is the difference between the standard and metrics folder?
example for generated prompt
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
How we check the errors before running the report,plz let me know the answer
How can we improve performance in framework manager level?
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What are the components used in web tier?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
Teradata 
