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 / m

IN Mysql we can do like this,
in that number starts from 0 so first parameter show
after LIMIT is row no. means here second row
and next 1 for limit that how many records do u want
to show. it means 1 record.


SELECT *
FROM `student_info`
LIMIT 1 , 1;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1127


what is a constraint? Tell me about its various levels. : Sql dba

984


What is the unique index?

1052


What is basic structure of pl sql?

1066


What is sql prepared statement?

977


how to use like conditions? : Sql dba

1105


What are inner and outer joins examples of both?

955


What do you think about pl/sql?

1026


What is sql architecture?

1046


What are aggregate functions in sql?

1156


What is query execution plan in sql?

1185


What are basic techniques of indexing?

1383


What is the difference between distinct and unique in sql?

946


What are the key differences between SQL and PL SQL?

1211


How many types of triggers are there in pl sql?

1066