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
- 12585 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 model filter?
What are the different uses of a repository manager?
can we insert all types of charts in a list report? what r the realtime prompts?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Write some methods to apply securities in framework manager model?
What is zero-foot print?
What are all the components of Report Studio?
What is the enterprise class platform architecture of cognos 8?
Can you define confirmed dimension?
Which lifecycle we will use for reporting?
what are the dimensions that you have in your current project?list them?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
-------------What is Coditional Prompting?
Can you explain a cognos controller?
Can you explain new content durability?
