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

How to revise and re-run the last sql command?

1101


what are local and global variables and their differences? : Sql dba

1010


How do you exit in sql?

1064


what are the types of subquery? : Sql dba

1053


Why procedure is used in sql?

977


What does the file extension accdb stand for?

919


Explain the the update statement in sql?

990


what is the difference between $message and $$message? : Sql dba

946


Does normalization improve performance?

982


How do I restart sql?

915


How long it takes to learn pl sql?

951


Is sqlite good enough for production?

950


What are the various levels of constraints?

1061


What is meant by user defined function?

988


What are stored procedures in mysql?

971