SQL: Significant supported features

  • Data types
    • All data types and data type support routines
    • domains

  • Operators
    • Support for equality operators across all data types, plus a lot more

  • Basic query specification
    • INSERT, DELETE, SELECT, UPDATE
    • SELECT DISTINCT, GROUP BY, HAVING, Aliases in FROM
    • CASE expression: CASE, NULLIF, COALESCE
    • core predicates: BETWEEN, IN, LIKE, NULL, EXISTS, Sub-selects in comparisons
    • query expressions: UNION, EXCEPT, INTERSECT, type coercion to allow table operations, table operations in sub-selects
    • joins: INNER, LEFT/RIGHT OUTER, FULL OUTER, CROSS, NATURAL, nested outer joins

  • Basic schema manipulation
    • CREATE/DROP SCHEMA, CREATE/ALTER/DROP TABLE, CREATE/DROP VIEW
    • Temporary tables
    • GRANT
Prev

Next

Page 23