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 do you mean by drill across?

0 Answers  

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

What is render variable?Where do you exactly use in developing a report?

3 Answers   IBM,

explain project, package ,model , modelers.........and differences b/w them?

4 Answers   HCL,

in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day

2 Answers   IBM, iFlex, iGate,

what is the use of layout calculation?

4 Answers  

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

1 Answers   IBM,

------------- How to identify the Revenue Column in Report?

0 Answers  

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

0 Answers  

What is Metrics designer?

0 Answers  

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

7 Answers   Cognizant, Cognos,

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers