Answer / madhoo

You are question is not clear.....you need decide based on
which column you want first 10 records.....

if you work on Salary column this is the query .......

select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/

Any queries on Sql please feel free to ask me i am very
interest in it......

Answer / srinu

select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;

Answer / don

we can create a list report and sort the field which we
need the top 10 of in an descending order and before
running the report set rows per page to 10

Answer / 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;

Answer / lakhwinder singh

Query for display the top 10 records from the table(tbl1)

select top 10 * from tbl1

Answer / sathish

select * from employee
limit 10

Answer / richard

Select Max(Count=10) from emp a

What are all types of prompt?

1 Answers  

what is session parameters? what is use?

1 Answers   HCL, Satyam,

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

What is the difference between macro & Parameter

1 Answers   IBM,

what is exact catalog size?

4 Answers   IBM,

What are slice and dice?

0 Answers  

Can you define framework manager?

0 Answers  

What are all the types of hierarchies?

0 Answers  

Explain is there any comparison available for cognos reportnet vs crystal reports?

0 Answers  

how you create security to reports?

0 Answers   IBM,

HI,can one suggest best institute for cognos Training in Hyderabad

14 Answers  

what are diff b/w cognos and business objects

6 Answers   HCL,