Long-overdue SQL standards

There has been no reference to SQL standards for a long time, and even SQL: 2011 updates have never been followed. The SQL standard has come along, so it can be said that it is a little old-fashioned, with fewer vendors involved and fewer followers. Most people refer to SQL standards, and the content involved is actually the most basic or core part of SQL89 or SQL92. In fact, since

There has been no reference to SQL standards for a long time, and even SQL: 2011 updates have never been followed. The SQL standard has come along, so it can be said that it is a little old-fashioned, with fewer vendors involved and fewer followers. Most people refer to SQL standards, and the content involved is actually the most basic or core part of SQL89 or SQL92. In fact, since

There has been no reference to SQL standards for a long time, and even SQL: 2011 updates have never been followed. The SQL standard has come along, so it can be said that it is a little old-fashioned, with fewer vendors involved and fewer followers. Most people refer to SQL standards, and the content involved is actually the most basic or core part of SQL89 or SQL92. In fact, since SQL: 1999, it has become a blessing. Most people do not need to read standards in a single word, and every time the standards are updated, members of the Committee will provide you with better introduction documents. For example, there is a good introduction to the latest SQL: 2011 and SIGMOD Record:

However, there are a lot of standard updates. This article only introduces the features related to non-time series databases. The following features are common:

1. DELETE in the MERGE statement

2. DML in the pipeline form: You can directly SELECT the header from the OLD and NEW tables.

3. Enhanced CALL statements

The official standard requires money, but the voting version before the official release can be downloaded. For example:

If you want to learn more, find the reference document of the First pdf file.