Skip to content
Advertisement

selecting all rows except top row using offset in MySQL

How can I use offset clause to get all rows except the first row. I am using query like

But this is not working in MySQL. what am I doing wrong here?

Advertisement

Answer

Sadly in MySQL OFFSET only works together with the LIMIT clause. So you need to use

or

I have chosen that limit number from a different question

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement