Difference in limit syntax in sql and mysql

Question

I'm learning database. I came across LIMIT keyword and its usage. In some tutorial it was specified as

LIMIT row_number OFFSET n will select row_number of rows after skipping n rows

And in another tutorial it was written as

LIMIT offset, row_number will select row_number of rows after skipping offset rows

Now which syntax is correct, if both are correct then where to use what?

yes i tried them and they are not working together, somewhere the first syntax is working and somewhere the other one, and hence the confusion @DarrenSweeney — trim24, Jul 11 '17 at 14:04
When does the first syntax work but not the second, and vice versa? — jarlh, Jul 11 '17 at 14:11
I am using online editors now. And the first syntax is working on sql and second one on mysql, but i'm not entirely sure. — trim24, Jul 11 '17 at 14:16

score 2 · Accepted Answer · answered Jul 11 '17 at 13:57

LIMIT row_number OFFSET n syntax is for MySQL, PostgreSQL and SQLite

LIMIT offset, row_number is for MySQL

Microsoft SQL Server uses a completely different approach: https://stackoverflow.com/a/10440718/234661

They are different because they haven't been standardized before being implemented.

score 0 · Answer 2 · answered Jul 11 '17 at 13:59

0

Both are same as they are generating same results.

The difference is only when you use second one LIMIT offset, row_number There is only syntax difference

You can use any of them based on your requirements

answered Jul 11 '17 at 13:59

M.suleman Khan

2 Answers2