Can you provide the full syntax of the SELECT statement in SQL, including all optional parts?

The full syntax of the SELECT statement in SQL includes several optional parts and can look like this:

SELECT [ALL | DISTINCT | DISTINCTROW] select_list
FROM table_references
[WHERE condition]
[GROUP BY grouping_columns]
[HAVING condition]
[WINDOW window_name AS (window_definition)]
[ORDER BY ordering_columns]
[LIMIT {[offset,] row_count} | {row_count OFFSET offset}]
[FETCH {FIRST | NEXT} [row_count] {ROW | ROWS} ONLY]
[FOR {UPDATE | SHARE} [OF table_name] [NOWAIT | SKIP LOCKED]]

Where:

• SELECT — the keyword for selecting data.
• ALL, DISTINCT, DISTINCTROW — options for selecting all or unique records.
• select_list — list of columns or expressions to select.
• FROM — tables or data sources.
• WHERE — filtering rows based on a condition.
• GROUP BY — grouping results.
• HAVING — filtering groups.
• WINDOW — defining window functions.
• ORDER BY — sorting results.
• LIMIT and OFFSET — limiting the number of returned rows.
• FETCH — an alternative way to limit the selection.
• FOR UPDATE and FOR SHARE — locking selected rows.

The syntax may vary slightly across different DBMSs, but this is the general full form.