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 the third record from the employee
table?

Answer Posted / i.anil

select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by drill through report?

964


how to merge 2 crosstabs thans

2637


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.

2505


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2043


1. Explain your project.

2042


Give me any example of semi and non additive measures?

963


what are the features in cognos8ui

2038


what is catalog and types of catalogs in cagnos and which is better?

1152


What are the different types of reports present in cognos?

982


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2440


in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1906


What is the importance of having monitor service in cognos?

1035


How can I schedule reports in cognos?

1001


please please give me some banking calculations in framework manager.

2081


What is defined as data mining?

1035