| B012 | | Embedded C | |
| B021 | | Direct SQL | |
| E011 | 核心 | Numeric data types | |
| E011-01 | 核心 | INTEGER and SMALLINT data types | |
| E011-02 | 核心 | REAL, DOUBLE PRECISION, and FLOAT data types | |
| E011-03 | 核心 | DECIMAL and NUMERIC data types | |
| E011-04 | 核心 | Arithmetic operators | |
| E011-05 | 核心 | Numeric comparison | |
| E011-06 | 核心 | Implicit casting among the numeric data types | |
| E021 | 核心 | Character data types | |
| E021-01 | 核心 | CHARACTER data type | |
| E021-02 | 核心 | CHARACTER VARYING data type | |
| E021-03 | 核心 | Character literals | |
| E021-04 | 核心 | CHARACTER_LENGTH function | trims trailing spaces from CHARACTER values before counting |
| E021-05 | 核心 | OCTET_LENGTH function | |
| E021-06 | 核心 | SUBSTRING function | |
| E021-07 | 核心 | Character concatenation | |
| E021-08 | 核心 | UPPER and LOWER functions | |
| E021-09 | 核心 | TRIM function | |
| E021-10 | 核心 | Implicit casting among the character string types | |
| E021-11 | 核心 | POSITION function | |
| E021-12 | 核心 | Character comparison | |
| E031 | 核心 | Identifiers | |
| E031-01 | 核心 | Delimited identifiers | |
| E031-02 | 核心 | Lower case identifiers | |
| E031-03 | 核心 | Trailing underscore | |
| E051 | 核心 | Basic query specification | |
| E051-01 | 核心 | SELECT DISTINCT | |
| E051-02 | 核心 | GROUP BY clause | |
| E051-04 | 核心 | GROUP BY can contain columns not in <select list> | |
| E051-05 | 核心 | Select list items can be renamed | AS is required |
| E051-06 | 核心 | HAVING clause | |
| E051-07 | 核心 | Qualified * in select list | |
| E051-08 | 核心 | Correlation names in the FROM clause | |
| E051-09 | 核心 | Rename columns in the FROM clause | |
| E061 | 核心 | Basic predicates and search conditions | |
| E061-01 | 核心 | Comparison predicate | |
| E061-02 | 核心 | BETWEEN predicate | |
| E061-03 | 核心 | IN predicate with list of values | |
| E061-04 | 核心 | LIKE predicate | |
| E061-05 | 核心 | LIKE predicate ESCAPE clause | |
| E061-06 | 核心 | NULL predicate | |
| E061-07 | 核心 | Quantified comparison predicate | |
| E061-08 | 核心 | EXISTS predicate | |
| E061-09 | 核心 | Subqueries in comparison predicate | |
| E061-11 | 核心 | Subqueries in IN predicate | |
| E061-12 | 核心 | Subqueries in quantified comparison predicate | |
| E061-13 | 核心 | Correlated subqueries | |
| E061-14 | 核心 | Search condition | |
| E071 | 核心 | Basic query expressions | |
| E071-01 | 核心 | UNION DISTINCT table operator | |
| E071-02 | 核心 | UNION ALL table operator | |
| E071-03 | 核心 | EXCEPT DISTINCT table operator | |
| E071-05 | 核心 | Columns combined via table operators need not have exactly the same data type | |
| E071-06 | 核心 | Table operators in subqueries | |
| E081-01 | 核心 | SELECT privilege | |
| E081-02 | 核心 | DELETE privilege | |
| E081-03 | 核心 | INSERT privilege at the table level | |
| E081-04 | 核心 | UPDATE privilege at the table level | |
| E081-06 | 核心 | REFERENCES privilege at the table level | |
| E081-08 | 核心 | WITH GRANT OPTION | |
| E081-10 | 核心 | EXECUTE privilege | |
| E091 | 核心 | Set functions | |
| E091-01 | 核心 | AVG | |
| E091-02 | 核心 | COUNT | |
| E091-03 | 核心 | MAX | |
| E091-04 | 核心 | MIN | |
| E091-05 | 核心 | SUM | |
| E091-06 | 核心 | ALL quantifier | |
| E091-07 | 核心 | DISTINCT quantifier | |
| E101 | 核心 | Basic data manipulation | |
| E101-01 | 核心 | INSERT statement | |
| E101-03 | 核心 | Searched UPDATE statement | |
| E101-04 | 核心 | Searched DELETE statement | |
| E111 | 核心 | Single row SELECT statement | |
| E121-01 | 核心 | DECLARE CURSOR | |
| E121-02 | 核心 | ORDER BY columns need not be in select list | |
| E121-03 | 核心 | Value expressions in ORDER BY clause | |
| E121-04 | 核心 | OPEN statement | |
| E121-08 | 核心 | CLOSE statement | |
| E121-10 | 核心 | FETCH statement implicit NEXT | |
| E121-17 | 核心 | WITH HOLD cursors | |
| E131 | 核心 | Null value support (nulls in lieu of values) | |
| E141 | 核心 | Basic integrity constraints | |
| E141-01 | 核心 | NOT NULL constraints | |
| E141-02 | 核心 | UNIQUE constraints of NOT NULL columns | |
| E141-03 | 核心 | PRIMARY KEY constraints | |
| E141-04 | 核心 | Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action | |
| E141-06 | 核心 | CHECK constraints | |
| E141-07 | 核心 | Column defaults | |
| E141-08 | 核心 | NOT NULL inferred on PRIMARY KEY | |
| E141-10 | 核心 | Names in a foreign key can be specified in any order | |
| E151 | 核心 | Transaction support | |
| E151-01 | 核心 | COMMIT statement | |
| E151-02 | 核心 | ROLLBACK statement | |
| E152 | 核心 | Basic SET TRANSACTION statement | |
| E152-01 | 核心 | SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause | |
| E152-02 | 核心 | SET TRANSACTION statement: READ ONLY and READ WRITE clauses | |
| E161 | 核心 | SQL comments using leading double minus | |
| E171 | 核心 | SQLSTATE support | |
| F021 | 核心 | Basic information schema | |
| F021-01 | 核心 | COLUMNS view | |
| F021-02 | 核心 | TABLES view | |
| F021-03 | 核心 | VIEWS view | |
| F021-04 | 核心 | TABLE_CONSTRAINTS view | |
| F021-05 | 核心 | REFERENTIAL_CONSTRAINTS view | |
| F021-06 | 核心 | CHECK_CONSTRAINTS view | |
| F031 | 核心 | Basic schema manipulation | |
| F031-01 | 核心 | CREATE TABLE statement to create persistent base tables | |
| F031-02 | 核心 | CREATE VIEW statement | |
| F031-03 | 核心 | GRANT statement | |
| F031-04 | 核心 | ALTER TABLE statement: ADD COLUMN clause | |
| F031-13 | 核心 | DROP TABLE statement: RESTRICT clause | |
| F031-16 | 核心 | DROP VIEW statement: RESTRICT clause | |
| F031-19 | 核心 | 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 | 核心 | Basic joined table | |
| F041-01 | 核心 | Inner join (but not necessarily the INNER keyword) | |
| F041-02 | 核心 | INNER keyword | |
| F041-03 | 核心 | LEFT OUTER JOIN | |
| F041-04 | 核心 | RIGHT OUTER JOIN | |
| F041-05 | 核心 | Outer joins can be nested | |
| F041-07 | 核心 | The inner table in a left or right outer join can also be used in an inner join | |
| F041-08 | 核心 | All comparison operators are supported (rather than just =) | |
| F051 | 核心 | Basic date and time | |
| F051-01 | 核心 | DATE data type (including support of DATE literal) | |
| F051-02 | 核心 | TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 | |
| F051-03 | 核心 | TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 | |
| F051-04 | 核心 | Comparison predicate on DATE, TIME, and TIMESTAMP data types | |
| F051-05 | 核心 | Explicit CAST between datetime types and character string types | |
| F051-06 | 核心 | CURRENT_DATE | |
| F051-07 | 核心 | LOCALTIME | |
| F051-08 | 核心 | LOCALTIMESTAMP | |
| F052 | 增強日期時間設施 | Intervals and datetime arithmetic | |
| F053 | | OVERLAPS predicate | |
| F081 | 核心 | 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 | 核心 | Grouped operations | |
| F131-01 | 核心 | WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views | |
| F131-02 | 核心 | Multiple tables supported in queries with grouped views | |
| F131-03 | 核心 | Set functions supported in queries with grouped views | |
| F131-04 | 核心 | Subqueries with GROUP BY and HAVING clauses and grouped views | |
| F131-05 | 核心 | Single row SELECT with GROUP BY and HAVING clauses and grouped views | |
| F171 | | Multiple schemas per user | |
| F191 | 增強完整性管理 | Referential delete actions | |
| F201 | 核心 | CAST function | |
| F221 | 核心 | 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 | 核心 | CASE expression | |
| F261-01 | 核心 | Simple CASE | |
| F261-02 | 核心 | Searched CASE | |
| F261-03 | 核心 | NULLIF | |
| F261-04 | 核心 | COALESCE | |
| 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 | 核心 | CREATE SCHEMA | |
| F311-02 | 核心 | CREATE TABLE for persistent base tables | |
| F311-03 | 核心 | CREATE VIEW | |
| F311-05 | 核心 | 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 | |
| F391 | | Long identifiers | |
| F401 | | Extended joined table | |
| F401-01 | | NATURAL JOIN | |
| F401-02 | | FULL OUTER JOIN | |
| F401-04 | | CROSS JOIN | |
| F411 | 增強日期時間設施 | 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 | |
| F471 | 核心 | Scalar subquery values | |
| F481 | 核心 | Expanded NULL predicate | |
| F491 | 增強完整性管理 | Constraint management | |
| F501 | 核心 | Features and conformance views | |
| F501-01 | 核心 | SQL_FEATURES view | |
| F501-02 | 核心 | SQL_SIZING view | |
| F501-03 | 核心 | 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 seconds precision | |
| F561 | | Full value expressions | |
| F571 | | Truth value tests | |
| F591 | | Derived tables | |
| F611 | | Indicator data types | |
| F651 | | Catalog name qualifiers | |
| F672 | | Retrospective check constraints | |
| F701 | 增強完整性管理 | Referential update actions | |
| F711 | | ALTER domain | |
| F761 | | Session management | |
| F771 | | Connection management | |
| F781 | | Self-referencing operations | |
| F791 | | Insensitive cursors | |
| F801 | | Full set function | |
| S071 | 增強的對象支持 | SQL paths in function and type name resolution | |
| S111 | 增強的對象支持 | ONLY in query expressions | |
| S211 | 增強的對象支持 | User-defined cast functions | |
| T031 | | BOOLEAN data type | |
| T071 | | BIGINT data type | |
| T141 | | SIMILAR predicate | |
| T151 | | DISTINCT predicate | |
| T171 | | LIKE clause in table definition | |
| T191 | 增強完整性管理 | Referential action RESTRICT | |
| T201 | 增強完整性管理 | Comparable data types for referential constraints | |
| T211-01 | 激活數據庫，增強完整性管理 | Triggers activated on UPDATE, INSERT, or DELETE of one base table | |
| T211-02 | 激活數據庫，增強完整性管理 | BEFORE triggers | |
| T211-03 | 激活數據庫，增強完整性管理 | AFTER triggers | |
| T211-04 | 激活數據庫，增強完整性管理 | FOR EACH ROW triggers | |
| T211-07 | 激活數據庫，增強完整性管理 | TRIGGER privilege | |
| T212 | 增強完整性管理 | Enhanced trigger capability | |
| T231 | | Sensitive cursors | |
| T241 | | START TRANSACTION statement | |
| T271 | | Savepoints | |
| T312 | | OVERLAY function | |
| T321-01 | 核心 | User-defined functions with no overloading | |
| T321-03 | 核心 | Function invocation | |
| T321-06 | 核心 | ROUTINES view | |
| T321-07 | 核心 | PARAMETERS view | |
| T322 | PSM | Overloading of SQL-invoked functions and procedures | |
| T323 | | Explicit security for external routines | |
| T351 | | Bracketed SQL comments (/*...*/ comments) | |
| T441 | | ABS and MOD functions | |
| T461 | | Symmetric BETWEEN predicate | |
| T501 | | Enhanced EXISTS predicate | |
| T551 | | Optional key words for default syntax | |
| T581 | | Regular expression substring function | |
| T591 | | UNIQUE constraints of possibly null columns | |