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...

how to find 5th row ?

Answer Posted / alok narayan

1.
select * from emp e1 where 5 =( select count(rowid) from
emp e2 where e1.rowid >= e2.rowid) ;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between nested subquery and correlated subquery?

1091


What are the types of sql commands?

1151


Can we use having without group by in sql?

1043


When is the update_statistics command used?

1179


What are types of exception?

959


What is the location of pre_defined_functions.

1206


What are the types of variable use in pl sql?

1132


How many row comparison operators are used while working with a subquery?

1069


How is sql used in oracle?

1037


What are crud methods?

1081


Is oracel sql developer written in java?

1163


What is data type in database?

1039


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1171


What is rowtype?

1079


Who is the owner of mysql database?

1103