write a query to display to 10 max record from the employee
table?
- 2 Answers
- 5132 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 |
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
How security is concerned with Reportnet? Explain its implementing steps.
What do you mean by drill across?
what is slowly growing dimension??
How can we create a dynamic column name in cognos?
what is dynamic sort?
Can you define a catalog and types of catalogs in cognos?
If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in
What is meant by grouped star schema
What is defined as Query studio?
What is meant by Tabular SQL in Cognos Report net
What is main advantage datawarehousing over oracle?
Teradata 
