Firebird Documentation IndexFirebird 2.5 Language Ref. Update → DML statements
Firebird Home Firebird Home Prev: VIEWFirebird Documentation IndexUp: Firebird 2.5 Language Ref. UpdateNext: DELETE

Chapter 7: DML statements

Table of Contents

DELETE
COLLATE subclause for text BLOB columns
ORDER BY
PLAN
Relation alias makes real name unavailable
RETURNING
ROWS
EXECUTE BLOCK
COLLATE in variable and parameter declarations
NOT NULL in variable and parameter declarations
Domains instead of data types
TYPE OF COLUMN in parameter and variable declarations
EXECUTE PROCEDURE
INSERT
INSERT ... DEFAULT VALUES
RETURNING clause
UNION allowed in feeding SELECT
MERGE
SELECT
Aggregate functions: Extended functionality
[AS] before relation alias
COLLATE subclause for text BLOB columns
Common Table Expressions (WITH ... AS ... SELECT)
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
Changed SET semantics
COLLATE subclause for text BLOB columns
ORDER BY
PLAN
Relation alias makes real name unavailable
RETURNING
ROWS
UPDATE OR INSERT
Prev: VIEWFirebird Documentation IndexUp: Firebird 2.5 Language Ref. UpdateNext: DELETE
Firebird Documentation IndexFirebird 2.5 Language Ref. Update → DML statements