• SQL:1999 (also called SQL 3) was the fourth revision of the SQL database query language. It introduced many new features, many of which required clarifications...
    8 KB (722 words) - 17:47, 9 February 2025
  • Structured Query Language (SQL) (pronounced /ˌɛsˌkjuˈɛl/ S-Q-L; or alternatively as /ˈsiːkwəl/ "sequel") is a domain-specific language used to manage...
    45 KB (4,009 words) - 10:38, 28 April 2025
  • The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available....
    35 KB (3,960 words) - 20:59, 25 January 2025
  • SQL:2023 or ISO/IEC 9075:2023 (under the general title "Information technology – Database languages – SQL") is the ninth edition of the ISO (1987) and...
    4 KB (391 words) - 10:47, 4 February 2025
  • The SQL SELECT statement returns a result set of rows, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database...
    33 KB (3,100 words) - 20:59, 25 January 2025
  • with SQL-92 entry level was scarcely any more demanding than conformance with SQL-89. Later revisions of the standard include SQL:1999 (SQL3), SQL:2003...
    4 KB (424 words) - 08:17, 13 February 2025
  • SQL:2011 or ISO/IEC 9075:2011 (under the general title "Information technology – Database languages – SQL") is the seventh revision of the ISO (1987)...
    9 KB (717 words) - 10:47, 4 February 2025
  • A GROUP BY statement in SQL specifies that a SQL SELECT statement partitions result rows into groups, based on their values in one or several columns....
    3 KB (334 words) - 17:57, 10 May 2025
  • of SQL-92 (ISO/IEC 9075-4:1996, a version sometimes called PSM-96 or even SQL-92/PSM), SQL/PSM was later incorporated into the multi-part SQL:1999 standard...
    7 KB (575 words) - 20:38, 3 June 2023
  • Thumbnail for Null (SQL)
    In SQL, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the creator of the relational...
    61 KB (7,610 words) - 11:03, 4 May 2025
  • detail in SQL. It was updated by SQL:2006. The SQL:2003 standard makes minor modifications to all parts of SQL:1999 (also known as SQL3), and officially...
    3 KB (248 words) - 10:47, 4 February 2025
  • recursive fixpoint queries, which compute transitive closures. In standard SQL:1999 hierarchical queries are implemented by way of recursive common table expressions...
    14 KB (1,377 words) - 10:03, 28 December 2024
  • 9075-13:2002 (part 13 of SQL:1999). SQL/JRT specifies the ability to invoke static Java methods as routines from within SQL applications, commonly referred...
    3 KB (339 words) - 18:28, 11 May 2020
  • Thumbnail for Trino (SQL query engine)
    ANSI SQL standard and includes various parts of the following ANSI specifications: SQL-92, SQL:1999, SQL:2003, SQL:2008, SQL:2011, SQL:2016, SQL:2023...
    9 KB (771 words) - 17:24, 27 December 2024
  • SQL:2016 or ISO/IEC 9075:2016 (under the general title "Information technology – Database languages – SQL") is the eighth revision of the ISO (1987) and...
    3 KB (235 words) - 10:47, 4 February 2025
  • Thumbnail for Boolean data type
    the Boolean data type (introduced in SQL:1999) is also defined to include more than two truth values, so that SQL Booleans can store all logical values resulting...
    26 KB (3,134 words) - 02:19, 29 April 2025
  • Structured type (category SQL)
    The SQL:1999 standard introduced a number of object–relational database features into SQL, chiefly among them structured user-defined types, usually called...
    3 KB (371 words) - 13:53, 6 December 2024
  • The history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the...
    44 KB (4,104 words) - 14:20, 24 March 2025
  • 12c claims conformance with SQL/OLB:1999, but not with the newer SQL/OLB:2008. SQL SQLJ (an outdated term for SQL/OLB) SQL:2003 Language Integrated Query...
    2 KB (205 words) - 03:30, 11 May 2022
  • Thumbnail for Object–relational database
    become incorporated into SQL:1999 via structured types. In fact, any product that adheres to the object-oriented aspects of SQL:1999 could be described as...
    12 KB (1,343 words) - 19:41, 30 August 2024
  • Bureau of Mines, Information Circular (1925), p. 42. Jim Melton, Alan R. Simon, SQL: 1999: Understanding Relational Language Components (2002), p. 50....
    6 KB (782 words) - 18:25, 30 April 2025
  • ISO/IEC 9075 (category SQL)
    edition SQL-92, ANSI X3.135-1992, ISO/IEC 9075:1992 - 3rd edition SQL:1999, ISO/IEC 9075:1999 - 4th edition SQL:2003, ISO/IEC 9075:2003 - 5th edition SQL:2006...
    2 KB (226 words) - 19:59, 19 March 2025
  • SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language. It was formally adopted in July 2008. The standard consists...
    2 KB (204 words) - 10:47, 4 February 2025
  • A Character Large OBject (or CLOB) is part of the SQL:1999 standard data types. It is a collection of character data in a database management system, usually...
    3 KB (326 words) - 10:10, 12 December 2024
  • SQLJ (category SQL data access)
    embedding of SQL statements into Java programs. SQLJ part 0 is the basis for part 10 of the SQL:1999 standard, aka SQL Object Language Bindings (SQL/OLB). SQLJ...
    7 KB (558 words) - 02:43, 7 September 2024
  • introduction of procedural elements to the SQL language in the SQL:1999 and SQL:2003 standards in the part SQL/PSM. That made SQL an imperative programming language...
    12 KB (1,298 words) - 23:08, 5 November 2024
  • Thumbnail for PostgreSQL
    database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation,...
    103 KB (8,667 words) - 23:09, 8 May 2025
  • SQL:2006 or ISO/IEC 9075:2006 standard is a revision part 14 (ISO/IEC 9075-14:2006) of the ISO standard for the SQL database query language. It is not...
    1 KB (155 words) - 10:47, 4 February 2025
  • been withdrawn, and replaced by ISO/IEC 9579:1999 - Information technology -- Remote Database Access for SQL, which has also been withdrawn, and replaced...
    4 KB (378 words) - 10:07, 8 July 2024
  • conforms with the SQL standard "SQL2 intermediate level" (SQL-92) and supports various features of SQL2 follow-on versions (SQL:1999, SQL:2003 etc.). As...
    8 KB (791 words) - 22:36, 24 April 2024