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

Explain architecture of sql server notification services?

1065


Why functions are used in sql?

999


What is materialized view in sql?

926


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1151


What are different types of queries in sql?

1122


how to calculate the difference between two dates? : Sql dba

1065


how to use case expression? : Sql dba

1031


What is input buffer in sql*plus?

1231


What is the benefit of foreign key?

1023


Explain foreign key in sql?

1039


How do I save the results of sql query in a file?

980


What is difference between left and right outer join?

994


what is a record in a database ? : Sql dba

1069


What is query syntax?

980


what is union? : Sql dba

1033