Write your SQL Queries the RIGHT Way

Understand the order of execution of the SQL queries

Image by Author

Did you know that there is a right way of writing SQL queries? A way that can help you to reduce syntactic errors in your query to almost zero!

The hack is to think like a SQL executor and understand the order of execution of your SQL queries.

Order of execution of the SQL queries!

Following is an example of a SQL query and there is a specific execution order that is followed by this SQL query.

We will be using the following tables to understand it practically:

OrderDetails (Image by Author)

Product Details (Image by Author)

1. From and Join: The 1st step in the execution chain is to read the data table (using FROM)…