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 / sunil bisht

Hi Shajin
above answere is perfectly correct.
but i have one more method..


select * from emp where rownum<6 minus select * from emp
where rownum<=4;

Is This Answer Correct ?    22 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why sql query is slow?

1006


How does postgresql compare to oracle/db2/ms sql server/informix?

1042


What are the parts of a basic sql query?

983


how to include numeric values in sql statements? : Sql dba

1110


How do I count rows in sql?

1013


What is sql partition function?

1219


What are the triggers associated with image items?

1050


How do I find sql profiler?

951


How do I pipe the output of one isql to another?

1010


What is data type in sql?

974


What is query optimization in sql?

990


What are the most important ddl statements in sql?

1126


Why do we need pl sql?

985


Does inner join remove duplicates?

948


How does cross join work in sql?

1027