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

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

Question Posted / sekhar

2 Answers
5645 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / lakshmi reddy

top 10 records
select * from emp where rownum<=10

Based on maximum salary(hithest top 10 salaries with details)
select * from (select emp.* from emp order by sal desc)
where rownum<=10

Is This Answer Correct ?

0 Yes

0 No

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

Answer / harish

based on salary top 10 records for emp table

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Cognos Interview Questions

pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com

1 Answers

How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).

1 Answers

What snowflake and Starschema?

2 Answers HCL,

What do you understand by the term 'dynamic cube'?

0 Answers

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

0 Answers

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers

What are the ways to import data into catalog?