Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

What is the difference between the standard and metrics folder?

0 Answers  


drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,


How do you improve the performance of the Cognos Analytics report

0 Answers  


What are all the types of gateway used in Cognos?

0 Answers  


Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!

2 Answers  


What are differences between Reporter report and Explorer report?

2 Answers  


what is the difference between Cognos EP7 series and Congos8?

2 Answers   Hexaware,


What r the names of the reports that you prepared?

0 Answers  


tell me the creation of Snapshots?

2 Answers  


How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,


----------------What is Surrogate Key?

1 Answers   Cap Gemini,


How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..

2 Answers   IBM,


Categories