mySQL skip n records?

[RetroDreams]

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?

[Dismounted]

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

[Marco van Herwaarden]

Or just: LIMIT 10,x

Where x is the number of rows to retrieve.

[Dismounted]

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

[RetroDreams]

Originally Posted by Dismounted

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.