write a query to display to 10 max record from the employee
table?
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 Metrics designer?
------------- How to identify the Revenue Column in Report?
How can create users and permissions in cognos?
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
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
how to create measures and dimensions?
how to connect datamarts
Define catalog in cognos and write its various types?
Can you define metrics designer?
What is main difference mapplets and mapping?
what is a prompt value in report studio and variables ?
What are the components of the report studio?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What are the ways to import data into catalog?