| B012 | Embedded C |
| B021 | Direct SQL |
| E011 | Core | Numeric data types |
| E011-01 | Core | INTEGER and SMALLINT data types |
| E011-02 | Core | REAL, DOUBLE PRECISION, and FLOAT data types |
| E011-03 | Core | DECIMAL and NUMERIC data types |
| E011-04 | Core | Arithmetic operators |
| E011-05 | Core | Numeric comparison |
| E011-06 | Core | Implicit casting among the numeric data types |
| E021 | Core | Character data types |
| E021-01 | Core | CHARACTER data type |
| E021-02 | Core | CHARACTER VARYING data type |
| E021-03 | Core | Character literals |
| E021-04 | Core | CHARACTER_LENGTH function | trims trailing spaces from CHARACTER values before counting |
| E021-05 | Core | OCTET_LENGTH function |
| E021-06 | Core | SUBSTRING function |
| E021-07 | Core | Character concatenation |
| E021-08 | Core | UPPER and LOWER functions |
| E021-09 | Core | TRIM function |
| E021-10 | Core | Implicit casting among the character string types |
| E021-11 | Core | POSITION function |
| E021-12 | Core | Character comparison |
| E031 | Core | Identifiers |
| E031-01 | Core | Delimited identifiers |
| E031-02 | Core | Lower case identifiers |
| E031-03 | Core | Trailing underscore |
| E051 | Core | Basic query specification |
| E051-01 | Core | SELECT DISTINCT |
| E051-02 | Core | GROUP BY clause |
| E051-04 | Core | GROUP BY can contain columns not in <select list> |
| E051-05 | Core | Select list items can be renamed |
| E051-06 | Core | HAVING clause |
| E051-07 | Core | Qualified * in select list |
| E051-08 | Core | Correlation names in the FROM clause |
| E051-09 | Core | Rename columns in the FROM clause |
| E061 | Core | Basic predicates and search conditions |
| E061-01 | Core | Comparison predicate |
| E061-02 | Core | BETWEEN predicate |
| E061-03 | Core | IN predicate with list of values |
| E061-04 | Core | LIKE predicate |
| E061-05 | Core | LIKE predicate ESCAPE clause |
| E061-06 | Core | NULL predicate |
| E061-07 | Core | Quantified comparison predicate |
| E061-08 | Core | EXISTS predicate |
| E061-09 | Core | Subqueries in comparison predicate |
| E061-11 | Core | Subqueries in IN predicate |
| E061-12 | Core | Subqueries in quantified comparison predicate |
| E061-13 | Core | Correlated subqueries |
| E061-14 | Core | Search condition |
| E071 | Core | Basic query expressions |
| E071-01 | Core | UNION DISTINCT table operator |
| E071-02 | Core | UNION ALL table operator |
| E071-03 | Core | EXCEPT DISTINCT table operator |
| E071-05 | Core | Columns combined via table operators need not have exactly the same data type |
| E071-06 | Core | Table operators in subqueries |
| E081 | Core | Basic Privileges |
| E081-01 | Core | SELECT privilege |
| E081-02 | Core | DELETE privilege |
| E081-03 | Core | INSERT privilege at the table level |
| E081-04 | Core | UPDATE privilege at the table level |
| E081-05 | Core | UPDATE privilege at the column level |
| E081-06 | Core | REFERENCES privilege at the table level |
| E081-07 | Core | REFERENCES privilege at the column level |
| E081-08 | Core | WITH GRANT OPTION |
| E081-09 | Core | USAGE privilege |
| E081-10 | Core | EXECUTE privilege |
| E091 | Core | Set functions |
| E091-01 | Core | AVG |
| E091-02 | Core | COUNT |
| E091-03 | Core | MAX |
| E091-04 | Core | MIN |
| E091-05 | Core | SUM |
| E091-06 | Core | ALL quantifier |
| E091-07 | Core | DISTINCT quantifier |
| E101 | Core | Basic data manipulation |
| E101-01 | Core | INSERT statement |
| E101-03 | Core | Searched UPDATE statement |
| E101-04 | Core | Searched DELETE statement |
| E111 | Core | Single row SELECT statement |
| E121 | Core | Basic cursor support |
| E121-01 | Core | DECLARE CURSOR |
| E121-02 | Core | ORDER BY columns need not be in select list |
| E121-03 | Core | Value expressions in ORDER BY clause |
| E121-04 | Core | OPEN statement |
| E121-06 | Core | Positioned UPDATE statement |
| E121-07 | Core | Positioned DELETE statement |
| E121-08 | Core | CLOSE statement |
| E121-10 | Core | FETCH statement implicit NEXT |
| E121-17 | Core | WITH HOLD cursors |
| E131 | Core | Null value support (nulls in lieu of values) |
| E141 | Core | Basic integrity constraints |
| E141-01 | Core | NOT NULL constraints |
| E141-02 | Core | UNIQUE constraints of NOT NULL columns |
| E141-03 | Core | PRIMARY KEY constraints |
| E141-04 | Core | Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action |
| E141-06 | Core | CHECK constraints |
| E141-07 | Core | Column defaults |
| E141-08 | Core | NOT NULL inferred on PRIMARY KEY |
| E141-10 | Core | Names in a foreign key can be specified in any order |
| E151 | Core | Transaction support |
| E151-01 | Core | COMMIT statement |
| E151-02 | Core | ROLLBACK statement |
| E152 | Core | Basic SET TRANSACTION statement |
| E152-01 | Core | SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause |
| E152-02 | Core | SET TRANSACTION statement: READ ONLY and READ WRITE clauses |
| E153 | Core | Updatable queries with subqueries |
| E161 | Core | SQL comments using leading double minus |
| E171 | Core | SQLSTATE support |
| F021 | Core | Basic information schema |
| F021-01 | Core | COLUMNS view |
| F021-02 | Core | TABLES view |
| F021-03 | Core | VIEWS view |
| F021-04 | Core | TABLE_CONSTRAINTS view |
| F021-05 | Core | REFERENTIAL_CONSTRAINTS view |
| F021-06 | Core | CHECK_CONSTRAINTS view |
| F031 | Core | Basic schema manipulation |
| F031-01 | Core | CREATE TABLE statement to create persistent base tables |
| F031-02 | Core | CREATE VIEW statement |
| F031-03 | Core | GRANT statement |
| F031-04 | Core | ALTER TABLE statement: ADD COLUMN clause |
| F031-13 | Core | DROP TABLE statement: RESTRICT clause |
| F031-16 | Core | DROP VIEW statement: RESTRICT clause |
| F031-19 | Core | REVOKE statement: RESTRICT clause |
| F032 | CASCADE drop behavior |
| F033 | ALTER TABLE statement: DROP COLUMN clause |
| F034 | Extended REVOKE statement |
| F034-01 | REVOKE statement performed by other than the owner of a schema object |
| F034-02 | REVOKE statement: GRANT OPTION FOR clause |
| F034-03 | REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION |
| F041 | Core | Basic joined table |
| F041-01 | Core | Inner join (but not necessarily the INNER keyword) |
| F041-02 | Core | INNER keyword |
| F041-03 | Core | LEFT OUTER JOIN |
| F041-04 | Core | RIGHT OUTER JOIN |
| F041-05 | Core | Outer joins can be nested |
| F041-07 | Core | The inner table in a left or right outer join can also be used in an inner join |
| F041-08 | Core | All comparison operators are supported (rather than just =) |
| F051 | Core | Basic date and time |
| F051-01 | Core | DATE data type (including support of DATE literal) |
| F051-02 | Core | TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 |
| F051-03 | Core | TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 |
| F051-04 | Core | Comparison predicate on DATE, TIME, and TIMESTAMP data types |
| F051-05 | Core | Explicit CAST between datetime types and character string types |
| F051-06 | Core | CURRENT_DATE |
| F051-07 | Core | LOCALTIME |
| F051-08 | Core | LOCALTIMESTAMP |
| F052 | Enhanced datetime facilities | Intervals and datetime arithmetic |
| F053 | OVERLAPS predicate |
| F081 | Core | UNION and EXCEPT in views |
| F111 | Isolation levels other than SERIALIZABLE |
| F111-01 | READ UNCOMMITTED isolation level |
| F111-02 | READ COMMITTED isolation level |
| F111-03 | REPEATABLE READ isolation level |
| F131 | Core | Grouped operations |
| F131-01 | Core | WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views |
| F131-02 | Core | Multiple tables supported in queries with grouped views |
| F131-03 | Core | Set functions supported in queries with grouped views |
| F131-04 | Core | Subqueries with GROUP BY and HAVING clauses and grouped views |
| F131-05 | Core | Single row SELECT with GROUP BY and HAVING clauses and grouped views |
| F171 | Multiple schemas per user |
| F191 | Enhanced integrity management | Referential delete actions |
| F200 | TRUNCATE TABLE statement |
| F201 | Core | CAST function |
| F202 | TRUNCATE TABLE: identity column restart option |
| F221 | Core | Explicit defaults |
| F222 | INSERT statement: DEFAULT VALUES clause |
| F231 | Privilege tables |
| F231-01 | TABLE_PRIVILEGES view |
| F231-02 | COLUMN_PRIVILEGES view |
| F231-03 | USAGE_PRIVILEGES view |
| F251 | Domain support |
| F261 | Core | CASE expression |
| F261-01 | Core | Simple CASE |
| F261-02 | Core | Searched CASE |
| F261-03 | Core | NULLIF |
| F261-04 | Core | COALESCE |
| F262 | Extended CASE expression |
| F271 | Compound character literals |
| F281 | LIKE enhancements |
| F302 | INTERSECT table operator |
| F302-01 | INTERSECT DISTINCT table operator |
| F302-02 | INTERSECT ALL table operator |
| F304 | EXCEPT ALL table operator |
| F311-01 | Core | CREATE SCHEMA |
| F311-02 | Core | CREATE TABLE for persistent base tables |
| F311-03 | Core | CREATE VIEW |
| F311-04 | Core | CREATE VIEW: WITH CHECK OPTION |
| F311-05 | Core | GRANT statement |
| F321 | User authorization |
| F361 | Subprogram support |
| F381 | Extended schema manipulation |
| F381-01 | ALTER TABLE statement: ALTER COLUMN clause |
| F381-02 | ALTER TABLE statement: ADD CONSTRAINT clause |
| F381-03 | ALTER TABLE statement: DROP CONSTRAINT clause |
| F382 | Alter column data type |
| F383 | Set column not null clause |
| F384 | Drop identity property clause |
| F386 | Set identity column generation clause |
| F391 | Long identifiers |
| F392 | Unicode escapes in identifiers |
| F393 | Unicode escapes in literals |
| F401 | Extended joined table |
| F401-01 | NATURAL JOIN |
| F401-02 | FULL OUTER JOIN |
| F401-04 | CROSS JOIN |
| F402 | Named column joins for LOBs, arrays, and multisets |
| F411 | Enhanced datetime facilities | Time zone specification | differences regarding literal interpretation |
| F421 | National character |
| F431 | Read-only scrollable cursors |
| F431-01 | FETCH with explicit NEXT |
| F431-02 | FETCH FIRST |
| F431-03 | FETCH LAST |
| F431-04 | FETCH PRIOR |
| F431-05 | FETCH ABSOLUTE |
| F431-06 | FETCH RELATIVE |
| F441 | Extended set function support |
| F442 | Mixed column references in set functions |
| F471 | Core | Scalar subquery values |
| F481 | Core | Expanded NULL predicate |
| F491 | Enhanced integrity management | Constraint management |
| F501 | Core | Features and conformance views |
| F501-01 | Core | SQL_FEATURES view |
| F501-02 | Core | SQL_SIZING view |
| F501-03 | Core | SQL_LANGUAGES view |
| F502 | Enhanced documentation tables |
| F502-01 | SQL_SIZING_PROFILES view |
| F502-02 | SQL_IMPLEMENTATION_INFO view |
| F502-03 | SQL_PACKAGES view |
| F531 | Temporary tables |
| F555 | Enhanced datetime facilities | Enhanced seconds precision |
| F561 | Full value expressions |
| F571 | Truth value tests |
| F591 | Derived tables |
| F611 | Indicator data types |
| F641 | Row and table constructors |
| F651 | Catalog name qualifiers |
| F661 | Simple tables |
| F672 | Retrospective check constraints |
| F690 | Collation support | but no character set support |
| F692 | Extended collation support |
| F701 | Enhanced integrity management | Referential update actions |
| F711 | ALTER domain |
| F731 | INSERT column privileges |
| F751 | View CHECK enhancements |
| F761 | Session management |
| F762 | CURRENT_CATALOG |
| F763 | CURRENT_SCHEMA |
| F771 | Connection management |
| F781 | Self-referencing operations |
| F791 | Insensitive cursors |
| F801 | Full set function |
| F850 | Top-level <order by clause> in <query expression> |
| F851 | <order by clause> in subqueries |
| F852 | Top-level <order by clause> in views |
| F855 | Nested <order by clause> in <query expression> |
| F856 | Nested <fetch first clause> in <query expression> |
| F857 | Top-level <fetch first clause> in <query expression> |
| F858 | <fetch first clause> in subqueries |
| F859 | Top-level <fetch first clause> in views |
| F860 | <fetch first row count> in <fetch first clause> |
| F861 | Top-level <result offset clause> in <query expression> |
| F862 | <result offset clause> in subqueries |
| F863 | Nested <result offset clause> in <query expression> |
| F864 | Top-level <result offset clause> in views |
| F865 | <offset row count> in <result offset clause> |
| S071 | Enhanced object support | SQL paths in function and type name resolution |
| S092 | Arrays of user-defined types |
| S095 | Array constructors by query |
| S096 | Optional array bounds |
| S098 | ARRAY_AGG |
| S111 | Enhanced object support | ONLY in query expressions |
| S201 | SQL-invoked routines on arrays |
| S201-01 | Array parameters |
| S201-02 | Array as result type of functions |
| S211 | Enhanced object support | User-defined cast functions |
| S301 | Enhanced UNNEST |
| T031 | BOOLEAN data type |
| T071 | BIGINT data type |
| T121 | WITH (excluding RECURSIVE) in query expression |
| T122 | WITH (excluding RECURSIVE) in subquery |
| T131 | Recursive query |
| T132 | Recursive query in subquery |
| T141 | SIMILAR predicate |
| T151 | DISTINCT predicate |
| T152 | DISTINCT predicate with negation |
| T171 | LIKE clause in table definition |
| T172 | AS subquery clause in table definition |
| T173 | Extended LIKE clause in table definition |
| T174 | Identity columns |
| T177 | Sequence generator support: simple restart option |
| T178 | Identity columns: simple restart option |
| T191 | Enhanced integrity management | Referential action RESTRICT |
| T201 | Enhanced integrity management | Comparable data types for referential constraints |
| T211-01 | Active database, Enhanced integrity management | Triggers activated on UPDATE, INSERT, or DELETE of one base table |
| T211-02 | Active database, Enhanced integrity management | BEFORE triggers |
| T211-03 | Active database, Enhanced integrity management | AFTER triggers |
| T211-04 | Active database, Enhanced integrity management | FOR EACH ROW triggers |
| T211-05 | Active database, Enhanced integrity management | Ability to specify a search condition that must be true before the trigger is invoked |
| T211-07 | Active database, Enhanced integrity management | TRIGGER privilege |
| T212 | Enhanced integrity management | Enhanced trigger capability |
| T213 | INSTEAD OF triggers |
| T231 | Sensitive cursors |
| T241 | START TRANSACTION statement |
| T271 | Savepoints |
| T281 | SELECT privilege with column granularity |
| T285 | Enhanced derived column names |
| T312 | OVERLAY function |
| T321-01 | Core | User-defined functions with no overloading |
| T321-02 | Core | User-defined stored procedures with no overloading |
| T321-03 | Core | Function invocation |
| T321-04 | Core | CALL statement |
| T321-06 | Core | ROUTINES view |
| T321-07 | Core | PARAMETERS view |
| T323 | Explicit security for external routines |
| T325 | Qualified SQL parameter references |
| T331 | Basic roles |
| T341 | Overloading of SQL-invoked functions and procedures |
| T351 | Bracketed SQL comments (/*...*/ comments) |
| T431 | OLAP | Extended grouping capabilities |
| T432 | Nested and concatenated GROUPING SETS |
| T433 | Multiargument GROUPING function |
| T441 | ABS and MOD functions |
| T461 | Symmetric BETWEEN predicate |
| T491 | LATERAL derived table |
| T501 | Enhanced EXISTS predicate |
| T521 | Named arguments in CALL statement |
| T551 | Optional key words for default syntax |
| T581 | Regular expression substring function |
| T591 | UNIQUE constraints of possibly null columns |
| T611 | OLAP | Elementary OLAP operations |
| T613 | Sampling |
| T614 | NTILE function |
| T615 | LEAD and LAG functions |
| T617 | FIRST_VALUE and LAST_VALUE function |
| T620 | WINDOW clause: GROUPS option |
| T621 | Enhanced numeric functions |
| T631 | Core | IN predicate with one list element |
| T651 | SQL-schema statements in SQL routines |
| T655 | Cyclically dependent routines |
| X010 | XML type |
| X011 | Arrays of XML type |
| X014 | Attributes of XML type |
| X016 | Persistent XML values |
| X020 | XMLConcat |
| X031 | XMLElement |
| X032 | XMLForest |
| X034 | XMLAgg |
| X035 | XMLAgg: ORDER BY option |
| X036 | XMLComment |
| X037 | XMLPI |
| X040 | Basic table mapping |
| X041 | Basic table mapping: nulls absent |
| X042 | Basic table mapping: null as nil |
| X043 | Basic table mapping: table as forest |
| X044 | Basic table mapping: table as element |
| X045 | Basic table mapping: with target namespace |
| X046 | Basic table mapping: data mapping |
| X047 | Basic table mapping: metadata mapping |
| X048 | Basic table mapping: base64 encoding of binary strings |
| X049 | Basic table mapping: hex encoding of binary strings |
| X050 | Advanced table mapping |
| X051 | Advanced table mapping: nulls absent |
| X052 | Advanced table mapping: null as nil |
| X053 | Advanced table mapping: table as forest |
| X054 | Advanced table mapping: table as element |
| X055 | Advanced table mapping: with target namespace |
| X056 | Advanced table mapping: data mapping |
| X057 | Advanced table mapping: metadata mapping |
| X058 | Advanced table mapping: base64 encoding of binary strings |
| X059 | Advanced table mapping: hex encoding of binary strings |
| X060 | XMLParse: character string input and CONTENT option |
| X061 | XMLParse: character string input and DOCUMENT option |
| X070 | XMLSerialize: character string serialization and CONTENT option |
| X071 | XMLSerialize: character string serialization and DOCUMENT option |
| X072 | XMLSerialize: character string serialization |
| X090 | XML document predicate |
| X120 | XML parameters in SQL routines |
| X121 | XML parameters in external routines |
| X222 | XML passing mechanism BY REF |
| X301 | XMLTable: derived column list option |
| X302 | XMLTable: ordinality column option |
| X303 | XMLTable: column default option |
| X304 | XMLTable: passing a context item |
| X400 | Name and identifier mapping |
| X410 | Alter column data type: XML type |