write a query to display to 10 max record from the employee
table?
- 2 Answers
- 4681 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 |
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
why we r using report studio in webbased only and fm windows based only
What is the use of content store in cognos?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
diff b/w layout calculation and query calculation
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
------------What is Slicer memberset?
where exactly determinants are used in cognos framework manager?
What are the advantages of using cognos sql?
What is difference between content store and content manager?
how u migrate the reports from impromptu to reportnet???
Can you define set to be cardinality?
Teradata 
