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
- 12902 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 set to be Cognos configuration?
Can you define snapshot?
What is difference between informatica power mart and power center?
Can you define set to be cardinality?
What are the types of security?
What is meant by drill down?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What are the advantages of cognos?
Can we test the report other than manual testing?
How to deploy from one server to another server?
What is Metrics designer?
Define the cognos reporting tool?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
can we insert all types of charts in a list report? what r the realtime prompts?
What is the use of powerhouse?
