Clauses supported by the SELECT statement
SELECT
statement- FROMIMPORTANT:You can also use subqueries allowed for theFROMclause and for theINpredicate.You need to use theFROMclause, the other clauses are optional.The clauses must have the following order:FROM,WHERE,GROUP,HAVING,ORDER,LIMIT.
- JOIN
- AS(alias for tables and columns, allowsregularanddelimitedidentifiers)
- WHERE
- GROUP BY
- ORDER BY
- Set function (COUNT,MAX,MIN,AVG,SUM)
- HAVING
- LIMITTIP:You can use theLIMIT OFFSETvariant to limit the number of records. The offset is optional and its default value is0.For example,SELECT * FROM Table1 LIMIT 1000 OFFSET 10returns 1000 records starting from the record number 10.
Provide Feedback