SQL-92 vs SQL:2016 Features

SQL-92 vs SQL:2016 Features is a SQL statement in the SELECT Queries category. SQL has evolved through many standards. Newer standards add JSON, row pattern matching, and polymorphic table functions. The syntax is -- SQL standards evolution: SQL-92 (foundation), SQL:1999 (CTE/triggers), SQL:2003 (window/XML), SQL:2016 (JSON/polymorphic).. It returns standard evolution. A typical example: -- SQL-92 (foundation): -- SELECT, JOIN, UNION, subqueries, constraints, transactions -- SQL:1999: -- Recursive CTE (WITH RECURSIVE) -- Triggers, INSTEAD OF triggers -- User-defined types (UDT) -- SQL:2003: -- Window functions (ROW_NUMBER, RANK, etc.) -- Sequences (CREATE SEQUENCE) -- MERGE statement -- XML support -- SQL:2008: -- TRUNCATE TABLE -- FETCH FIRST / OFFSET (pagination) -- INSTEAD OF triggers on views -- SQL:2016: -- JSON functions (JSON_VALUE, JSON_QUERY) -- Row… A close relative is SELECT, which retrieves data from a table. The most fundamental SQL statement. A close relative is SELECT *, which selects all columns from a table.