write a query to display to 10 max record from the employee
table?
Answer Posted / madhusudhan
select rownum rn,(select e.* from emp e)
order by sal desc
where rn>=&rn;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we create a dynamic column name in cognos?
Can you define folder?
How can I schedule reports in cognos?
what are the dimensions that you have in your current project?list them?
What are all the types of indexes in Cognos?
What is called materialized view?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
How can create users and permissions in cognos?
What is Metrics designer?
which type of project we r going to snowflake schema
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
Can you define confirmed dimension?
Can you define dimension?
What is the difference between the content store and content manager?
how you provide security to reports? How you provide security to packages ?