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 indexing methods?

1048


What is difference between primary and secondary key?

1027


what are the drivers in mysql? : Sql dba

1021


what are the performance and scalability characteristics of mysql? : Sql dba

996


Explain the structure of pl/sql in brief.

1095


how many tables will create when we create table, what are they? : Sql dba

1075


How do you get column names only for a table (sql server)?

1164


How to avoid using cursors?

1120


What do you mean by query optimization?

1002


Why do we need pl sql?

977


What are triggers and its uses?

1046


How to display the records between two range in Oracle SQL Plus?

1146


How do I tune a sql query?

974


Can we insert in sql function?

1084


What are the three forms of normalization?

1045