ANSI SQL 手册 [英] ANSI SQL Manual

问题描述

谁能推荐一本好的 ANSI SQL 参考手册?

Can anyone recommend a good ANSI SQL reference manual?

我不一定指的是教程，而是当您需要基本或更深入的解释或示例时可以查找的适当参考文档.

I don't necessary mean a tutorial but a proper reference document to lookup when you need either a basic or more in-depth explanation or example.

目前我正在使用 W3Schools SQL 教程 和 SQL 教程 不错，但我觉得它们不够深入".

Currently I am using W3Schools SQL Tutorial and SQL Tutorial which are ok, but I don't find them "deep" enough.

当然，每个主要的 RDBMS 生产商都会有一些针对他们自己产品的参考手册，但它们往往有偏见，有时会使用专有扩展.

Of course, each major RDBMS producer will have some sort of reference manuals targeting their own product, but they tend to be biased and sometime will use proprietary extensions.

已问题的目的是关注数据库引擎的共同点，即 SQL 根.但了解差异也可能是一件积极的事情 - 这个非常有趣.

EDITED: The aim of the question was to focus on the things database engines have in common i.e. the SQL roots. But understanding the differences can also be a positive thing - this is quite interesting.

推荐答案

这是 SQL:1992，对于我查过的所有内容，它似乎已经足够准确.1992 涵盖了 DBMS 中常规使用的大部分内容.

Here's the ‘Second Informal Review Draft’ of SQL:1992, which seems to have been accurate enough for everything I've looked up. 1992 covers most of the stuff routinely used across DBMSs.

这篇关于ANSI SQL 手册的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！