getting every 300th row

Luke101 · #1 (**permalink**) 09-04-07, 16:14

Hello,
I am interrested in getting every 300th row of my table. Is this possible to do in mysql? I'd prefer not to use the primary key to do this.

for example i need row 300, 600, 900, 1200..etc

quakey · #2 (**permalink**) 09-04-07, 17:20

I can only think of using % operator to achieve this.

I'd be very interested to know if there are other ways.

r937 · #3 (**permalink**) 09-04-07, 17:55

every 300th row based on what? imageuploadtimestamp? productweight? skillrating?

pasthana@netlink. · #4 (**permalink**) 07-22-11, 02:46

Hi,

it is not possible in single select statement.
u need to use some logic for it like loop or cursor.

Internet Services

Web Development

Digital Marketing

Consumer Tech