Oracle Rownum Functionality in MySQL

In oracle we use the RowNum for various reasons. Here we are focusing on the usage of RowNum on Select statement.

In MySql Limit will be the alternate to the RowNum feature. Additionally it can be used along with the Update / Delete statement. Example for the Limit usage is
Select * from table order by column A LIMIT