what is the non-standard words&usage in mysql

I'm using mysql for a while. I think to switch pdo, and want to use standard function. Can you provide non-standard syntax in mysql?

First think LIMIT in oracle they use rowcount, and mssql they use 开发者_StackOverflow中文版TOP .

Is this the question you are looking for:

There are a method to paging using ANSI SQL only?