Logical Processing Order Flashcards

1
Q

What r the logical processing steps?

A
FROM 
     ON
     JOIN
WHERE
GROUP BY
     WITH CUBE or ROLLUP
HAVING
SELECT
      Expressions e.g. CASE
      DISTINCT
ORDER BY
      TOP or OFFSET/FETCH
How well did you know this?
1
Not at all
2
3
4
5
Perfectly