insert into … select … final from (delete from …)
Data-Modifying Statements in With
(PostgreSQL)
Output
-clause (SQL Server)
Returning
-clause (Oracle, PostgreSQL)
T495,“Combined data change and retrieval” is an optional feature in ISO/IEC 9075-2:2016. It first appeared in ISO/IEC 9075-2:2011.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »