Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 8 Answers
- 12933 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rajasivam.p
To find nth value
select salary from emp a where &n=(select count(distinct
salary) from emp b where a.empno<=b.empno);
to find max by nth value a.empno<=b.empno
to find min by nth value a.empno>=b.empno
OR
To find 10 max records
select * from (select * from emp order by salary desc) where
rownum<=&n;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
is cognos 7 is better than cognos 8
What are the two types of framework manager?
what is log in cognos?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com What is defined as data mining? Please Answer this Questions:
1.In FWM We have to create Hierarchies, Condition is we
don't know the correct levels in the Hierarchies, in this
case how can we find out the levels
(year->Quarters->month->day)in data?
2. In FWM Standalone Filter is for Reusable purpose &
Embedded Filter we cant resuse.but is this possible to
convert the Embedded filter to standalone filter?
3.What are the differences between Relational Database Model
& Multi Dimensional Database?
4.In Drill Down/ Drill Up, How to specify the limits for
example in a report there is 6 Drill down is possible, but i
want only 3 Drill downs, the report should not allow 4 Th
Drill Down.How to make this ?
4. What are the limitations in Select and Search Prompt ?
What is the use of report studio? What r the names of the reports that you prepared? what is the role of cognos comsultant?what actually it
means?pls reply What is the diff between the following Report output-- HTML
O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs?
Listout main differences? 1. Explain your project.
What are the ways to import data into catalog? how you migrate reports to cognos 8 from previous versions?
