WITH name AS (SELECT…)
WITH RECURSIVE query_name AS (SELECT…)
recursive
• No join
in recursive branch—use comma-join (,
)recursive
FOR SYSTEM_TIME AS OF
for system_time
Click on one of the features on the left hand side, e.g. “With
clause”, to see how long the tested databases support this feature.
You cannot make up for 20 years of SQL evolution today. Subscribe the newsletter via E-Mail, Twitter or RSS to catch up successively and to keep modern-sql.com on your radar.
If you want to start right away I’d recommend the articles about the pivot method, the extract
expression and the with
clause for the beginning. These are among the most popular articles on modern-sql.com.
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 »
“Pages of specification” is as pointless as “lines of code”. Yet it might give you an impression about the growth.