can i select the 2nd row/record from a table

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,948 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,884 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 5634 | Replies: 2

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

ohgosh

Offline

Light Poster

can i select the 2nd row/record from a table

Sep 15th, 2005

Hi peeps...

A good day to all of you yea~ as i know, i can retrieve only the first row by using the keyword limit 1:

Help with Code Tags

(Toggle Plain Text)

select * from tblTesting limit 1

for selecting the first two rows are:

Help with Code Tags

(Toggle Plain Text)

select * from tblTesting limit 2

is there any solution to getting the second row? not the two rows but is second..

THANKS yea~

cheers,
ohgosh

•

Join Date: Jun 2005

Posts: 33

Reputation: comprookie2000 is an unknown quantity at this point

Rep Power: 4

Solved Threads: 3

comprookie2000 comprookie2000 is offline

Offline

Light Poster

Re: can i select the 2nd row/record from a table

Sep 16th, 2005

See if this helps, go down about halfway where he is working on tables etc. The first part is setting it up for gentoo but on down a little may be what you want.
http://www.gentoo.org/doc/en/mysql-howto.xml

Drupal Site

•

Join Date: Aug 2005

Location: Oklahoma

Posts: 902

Reputation: chrisbliss18 is an unknown quantity at this point

Rep Power: 4

Solved Threads: 21

chrisbliss18 chrisbliss18 is offline

Offline

Posting Shark

Re: can i select the 2nd row/record from a table

Sep 16th, 2005

The LIMIT directive can take one or two attributes. If you use one attribute, for example "LIMIT 5", it will show only that many records which get taken off of the top of the list of results. If you use two attributes, for example "LIMIT 10, 5", it will skip the number of records indicated by the first number and then show the number of records indicated by the second number. In other words it's "LIMIT skip, show". So to do what you want, execute:

Help with Code Tags

(Toggle Plain Text)