Order of Execution of a SQL Query | MySQL Tutorial

In this MySQL tutorial, order of execution of a SQL query is explained in detailed.

Flow :

From - Choose table to get the base data
Join - Obtain matching records from the other tables
Where - Filters the base data
Group by - Aggregates the data
Having - Filter the aggregated data
Select - Returns the final data
Order by - Sorts the final data
Limit / Offset - Limit the final data to a row count

#knowledgethrusters #mysql