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
- 12934 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / narender.v
select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal)
it will prompt for the value give the values as 10 u will
get the output
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How do we convert from Numeric to be Words?
What are various types of gateways in cognos?
how to perform single sign in cognos by using url?
What is model filter?
how u will design the report if the objects are available
What is difference between content store and content manager?
7. What is performance tuning?
How to Reset Pagenumbers in one report.
What do you mean by query studio?
what is the main advantage of impromptu over cognos reportnet?
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 folder?
What are the components of report net?
Explain what is the main advantage of impromptu over cognos reportnet?
what are the special features in cognos reportnet?
