write a query to display to 10 max record from the employee
table?
- 8 Answers
- 11594 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
Explain what is the difference between microstrategy and cognos reporting tool?
What you mean by drill across and what is the difference between drill through, drill across?
what is the difference between list report and crosstab report?
What is the difference between Standard and Metrics folder?
What is a Datastore in Cognos?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
----------------Describe DWH Architecture?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Can you define dimension?
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 is a Framework manager?
What is difference between page break and section report?
What are the types of studio present in Cognos?
Define dimensions?
What do you mean by query studio?
