How to make a select starting with a certain line

Asked

Viewed 1,039 times

2

How do I get one Select starting for example from the second row of my table?

I know that using the ASC limit 1,1 I can pick the second line, but how to start from it?

1 answer

2


You can put the second value of LIMIT as larger than the table can reach or value who thinks it appropriate.

Ex:

SELECT * FROM tabela ASC LIMIT 1,999999999999999999
  • Ingenious! But it should really work... :)

Browser other questions tagged

You are not signed in. Login or sign up in order to post.