What is executed first in SQL?
FROM clause is executed first because it forms the set of records all the following clauses (like WHERE and SELECT) will operate over.
  • SQL Query Order of Operations

    The order in which SQL directives get executed:
    • FROM clause
    • WHERE clause
    • GROUP BY clause
    • HAVING clause
    • SELECT clause
    • ORDER BY clause
    Read more: SQL Query Order of Operations
  • Optimization - FROM Clause

    Since this clause executes first, it is our first opportunity to narrow down possible record set sizes. This is why I put as many of my ON rules (for joins) as possible in this area as opposed to in the WHERE clause:
        contact c
        display_status d
                c.display_status_id = d.id
                d.is_active = 1
                d.is_viewable = 1 
    This way, by the time we get to the WHERE clause, we will have already excluded rows where is_active and is_viewable do not equal 1.
    Read more: SQL Query Order of Operations

Следи за CodeGalaxy

Мобильное приложение Beta

Get it on Google Play
Обратная Связь
Продолжайте изучать
тесты по SQL
Зарегистрируйся сейчас
или Подпишись на будущие тесты