Engine Specific Commands
SQL Commands (SQL Server)
Sections
Section 1: Querying Data
Section 2: Ordering Data
Section 3: Filtering Data
Section 4: Conditional Data
Section 5: Joining Data
Section 6: Aggregating Data
Section 7: Grouping Data
Section 8: Modifying Data
Order of Operations
Web Reference
When building SQL queries, the engine will execute each clause in a predefined order of execution.
FROM
- Specifies the table(s) or view(s) from which the data will be selected.
JOIN
- Combines the rows from the different tables based on a specified condition.
WHERE
- Filters the rows that meet a specified condition or set of conditions.
GROUP BY
- Groups the result set by one or more columns, and is used in combination with aggregate functions such as
COUNT, SUM, AVG, MIN, and MAX