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
- 12932 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhoo
select * from emp a
where (select count(distinct sal) from emp b where
a.sal<b.sal)=&n order by sal desc
/
this is the exact query........when there are duplicate
salaries are there also........
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is the function of model design accelerator?
Can you define metrics designer?
tell me two or three issues from client side and how to solve those issues?
How do we drill through from a powerplay cube to reportnet?\
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
is cognos 7 is better than cognos 8
What is looping and how to avoid it in framework manager?
What is cognos connection?
What is the difference between group and associare?
can we insert all types of charts in a list report? what r the realtime prompts?
What are the types of hierarchies?
What is defined as data mining?
What is Bitmap Index?
What are the steps to import the two data sources in framework manager?
What are the types of security?
