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
- 12898 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
What is the difference b/w macros and prompt?
How to generate cubes in cognos?
What is the difference between the standard and metrics folder?
What are all the components of Report Studio?
What is meant by Reportstudio shortcut?
Can you explain the advantage of using shortcuts?
What is a Query Subject?
Give me any example of semi and non additive measures?
What is the difference between a data mart and a data warehouse?
What are the services provided in cognos 8?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
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.
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
What you mean by drill across and what is the difference between drill through, drill across?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
