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 is model and say about process how to create model and how to test model?

0 Answers   IBM,

which type of project we r going to snowflake schema

0 Answers   IBM,

what is the security module used in cognos?

2 Answers   Cognos, IBM,

why u need to publish the package?

5 Answers   IBM,

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

What is the function of model design accelerator?

0 Answers  

Difference betwween cognos report net architecture and cognos8 architecture

3 Answers  

1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

2 Answers   Cognizant,

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

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

8 Answers   HCL,

A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

0 Answers  

How to schedule the report twice in a day?

2 Answers   Cognizant,