write a query to display to 10 max record from the employee
table?
- 2 Answers
- 5023 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 function of cognos dispatcher?
how can you get the errors in job? when loops are araised we get error?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the difference between regular dimension and derminant?
Is it possible to create drill through access to other report from PDF report?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
what is Associated grouping? and how it works in cognos impromptu?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
what are typees of dimensions
How do I remove the hyperlink from the drill through report?
What is the basic relationship between measures and dimensions in transformer modelling
Teradata 
