write a query to display to 10 max record from the employee
table?
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
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
how you migrate reports to cognos 8 from previous versions?
What is difference between content store and content manager?
How do we drill through from a powerplay cube to reportnet?\
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is the difference between regular dimension and derminant?
Define dimensions?
write a query to display the departments with no employee?
Can you define a catalog and types of catalogs in cognos?
-----------------What is Direct and Conventional loading?
Can you define transformer?
Can you define set to be cardinality?
how to explain health care project and which reports we can create in health care doain?
Explain what is the difference between microstrategy and cognos reporting tool?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw