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 is the purpose of the primary key?

1117


How do I start pl sql?

997


explain advantages of myisam over innodb? : Sql dba

1112


Explian rowid, rownum?

1086


Do ddl statements need commit?

1023


what are date and time data types in mysql? : Sql dba

1024


How is indexing done in search engines?

1023


Which is faster union or join?

1027


What is the best sql course?

1028


What is normalization in a database?

1198


How can we optimize a sql query?

1109


What are operators available in sql?

1096


What is a temporal table?

983


Differentiate pl/sql and sql?

1130


What is multiple columns?

1120