To display first 10 records we can write the query as select * from(selec

write a query to display to 10 max record from the employee
table?

Question Posted / m m naidu

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

Please Help Members By Posting Answers For Below Questions

What is model filter?

1104

What are the considerations regarding performance kept in mind while setting up cognos?

916

what are the special features in cognos reportnet?

998

What is a Query Subject?

1033

Can you define slice?

974

What are all the types of report?

1022

What are the message flows?

928

What is the difference between ‘macro’ and ‘prompt?

1002

hi friends pls forward impropmtu interview question

2073

Can you explain cognos planning?

1035

What is the importance of having monitor service in cognos?

979

What are shortcuts? Where it can be used? What are the advantages?

989

How do we drill through from a powerplay cube to reportnet?\

2294

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2469

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2251