write a query to display to 10 max record from the employee
table?
Answer Posted / m m naidu
To display first 10 records we can write the query as
select * from(select * from emp order by ename desc) where
ronum<=10;
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
what is the role of cognos comsultant?what actually it means?pls reply
What is difference between primary key and unique key constraints?
what is the difference between filter and condition?
-----------------What is Direct and Conventional loading?
What are the types of hierarchies?
What do you understand by the term 'model durability'?
Can you explain dynamic query mode?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
can we insert all types of charts in a list report? what r the realtime prompts?
Can you explain cognos planning?
What are the main services provided by application tier?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
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.
What are the other methods working as deployment functionality?
What is catalog and types of catalogs in cagonos and which is better?