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

how can we find the number of rows in a table using mysql? : Sql dba

1084


Enlist the characteristics of pl/sql?

1803


What is the limitation on the block size of pl/sql?

987


What is the difference between left and left outer join?

945


Which sql most popular?

991


Explain 3 basic parts of a trigger.

1323


What are the parameter modes supported by pl/sql?

1109


Is primary key clustered or nonclustered?

1021


What is difference between primary and secondary key?

1028


How do you remove duplicate records from a table?

941


Is left join faster than inner join?

1125


What is an emotional trigger?

1005


what is the difference between inner and outer join? Explain with example. : Sql dba

1026


What are the types of functions in sql?

1020


What is a join?

1069