In order to run the SQL queries in an efficient and effective way, the query is executed in a specific order. Understanding the order of execution helps you to understand how the required data is being fetched from the database so that you can optimize your queries if required. The order of execution is provided as FROM à JOINS à WHERE à GROUP BY à HAVING à SELECT à ORDER BY à LIMIT. Tip – You can memorise the order using the statement “From January We Gonna Have Sweet dishes OnLy”.