write a query to display to 10 max record from the employee
table?
- 2 Answers
- 5093 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 |
Explain the different stages in creating a report in cognos report net?
can we create master detail report where master and detailed container is separate?
Please explain the different stages in creating a report in cognos report net?
what is report view?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the types of catalogs in cognos?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
what is an outer join? difference between left outer join right outer join with an example?
what is model and say about process how to create model and how to test model?
Teradata 
