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 retrive only second row from table?

Answer Posted / anusha

select * from ars_mst_user where rownum<5
minus
select * from ars_mst_user where rownum<=3;

this query for retrive fourth row
same we can retrive any row

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the 'mysql' command line arguments? : Sql dba

1137


what is the difference difference between procedure and packages

10395


What is sql data?

989


What is the purpose of cursors in pl/sql?

1134


what is union, minus and interact commands? : Sql dba

1185


what is not null constraint? : Sql dba

1029


What is a common use of group by in sql?

1049


List and explain the different types of join clauses supported in ansi-standard sql?

1353


What are sql commands?

1010


What is the execution plan in sql?

1021


What is sql engine in oracle?

987


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1054


What are joins in sql?

1042


What is schema in sql?

946


What are instead of triggers?

1041