mySQL skip n records?
 

Is it possible to skip a set amount of records? For instance, say I run a query and sort the data but don't want to include the Top 10 posters, but everyone from 11 on -- can this be done in SQL?

If so, would I use the LIMIT and OFFSET commands? If not, what do I use?

You don't need to use LIMIT, you only need to use the OFFSET clause.

Or just: LIMIT 10,x

Where x is the number of rows to retrieve.

That would work if you knew how many rows there are. :)

Which I did, since I sorted them to get the Top n. I send up using the LIMIT x, y command like Marco said. Sorry for not replying that I figured it out.