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?

Answer Posted / 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;

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate cubes in cognos?

1017


what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

2549


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1124


What are all the types of hierarchies?

1177


hi my name is siraj i want to know cognos queriy language

2313


Define datastores in cognos?

999


Define query items?

1052


what is a prompt value in report studio and variables ?

2777


what are the errors faced while bursting the reports and how to solve those errors?

2068


What is cognos connection?

1347


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2135


Cleared COG-112 with 100% score today. What next certification should i go for?

1880


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2048


What are slice and dice?

976


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2153