2
Reply

What is the Order of SQL's Query Execution with below Statement?

Rajeev Kumar

Rajeev Kumar

2y
1.9k
0
Reply

ORDER BY->LIMIT/OFFSET->SELECT->HAVING-> GROUP BY->WHERE->From/Join

    Hi Rajeev

    the Order of SQL’s Query Execution is as below

    SELECT
    FROM
    JOIN (INNER, LEFT, RIGHT, FULL OUTER JOIN)
    WHERE
    GROUP BY
    HAVING
    ORDER BY
    LIMIT;

    Thanks
    Raj Bhatt

    Hi raj According to me Query Execution as below-
    FROM/JOIN:
    WHERE:
    GROUP BY:
    HAVING:
    SELECT:
    ORDER BY:
    LIMIT/OFFSET: