Chapter 6: DML statements

Table of Contents

DELETE

COLLATE subclause for text BLOB columns

ORDER BY

PLAN

Relation alias makes real name unavailable

ROWS

EXECUTE BLOCK

EXECUTE PROCEDURE

INSERT

RETURNING clause

UNION allowed in feeding SELECT

SELECT

Aggregate functions: Extended functionality

[AS] before relation alias

COLLATE subclause for text BLOB columns

Derived tables (“SELECT FROM SELECT”)

FIRST and SKIP

GROUP BY

HAVING: Stricter rules

JOIN

ORDER BY

PLAN

Relation alias makes real name unavailable

ROWS

UNION

WITH LOCK

UPDATE

COLLATE subclause for text BLOB columns

ORDER BY

PLAN

Relation alias makes real name unavailable

ROWS