SQL CLAUSES

SQL clauses help define how data is retrieved, filtered and manipulated. They provide a structured way to specify what data to include, how to organize it and what conditions must be met for rows to be included in the result set.

The following table summarizes the clauses supported by Oxla:

Clause Name	Description
FROM	Defines the source table(s) or view(s) for the query
WHERE	Filters rows based on specified conditions
GROUP BY	Groups rows sharing common values in specified columns for aggregation
HAVING	Filters grouped rows based on aggregate conditions
ORDER BY	Sorts the result set by specified columns in ascending or descending order
LIMIT	Restricts the number of rows returned by the query
OFFSET	Skips a specified number of rows before returning results
SET OPERATIONS	Combine or compare results from multiple SELECT statements, such as UNION, INTERSECT and EXCEPT
WITH	Creates temporary named result sets (Common Table Expressions) for reuse within queries
OVER	Specifies the window over which window functions to operate on subsets of data