write a query to display to 10 max record from the employee
table?
- 2 Answers
- 4654 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 Local Cache and how does it help in performance tuning
diff b/w dimension and regular dimension
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
How to select all in value prompt instead of cascade prompt?
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.
---------------Describe OLAP Reporting and RDBMS Reporting?
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?
2. What functional area you worked on.
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Teradata 
