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

how u migrate reports to cognos 8 from previous versions

3 Answers   TCS,

what are diff b/w cognos and business objects

6 Answers   HCL,

Can you explain model durability?

0 Answers  

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

does query is created for date prompt?

9 Answers  

Explain informatica architecture?

0 Answers  

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,

data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,

What is the use of Cognos scenario?

0 Answers  

what use of surgate key in project

3 Answers   HCL, TCS,

What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?

1 Answers   IBM, iFlex, TCS,