View source for Structured Query Language

You do not have permission to edit this page, for the following reason:

Your IP address is in a range that has been blocked on all Wikimedia Foundation wikis.

The block was made by ‪Jon Kolbert‬. The reason given is Open proxy/Webhost: See the help page if you are affected .

Start of block: 05:40, 21 February 2024
Expiry of block: 05:40, 21 February 2029

Your current IP address is 54.226.5.174. The blocked range is 54.226.0.0/16.

Please include all above details in any queries you make. If you believe you were blocked by mistake, you can find additional information and instructions in the No open proxies global policy.

Otherwise, to discuss the block please post a request for review on Meta-Wiki. You could also send an email to the stewards VRT queue at stewards@wikimedia.org including all above details.

You can view and copy the source of this page.

__NOTOC__
__NOEDITSECTION__

'''''[[w:SQL|Structured Query Language (SQL)]]''''' is a widely-used programming language for working with relational databases. The name of the language is generally pronounced as the three letters of its abbreviation {{Audio|En-us-SQL.ogg|help=no|ˈɛs kjuː ˈɛl}} or, in some people's usage, as {{Audio|En-us-sequel.ogg|help=no|ˈsiːkwəl}}.

This Wikibook provides a short description of SQL, its origins, basic concepts and components, and many examples. The book follows the specifications of the [[w:SQL:2011|SQL:2011]] standard developed by a common committee of [[w:International Organization for Standardization|ISO]] and [[w:International Electrotechnical Commission|IEC]]. Their publications are not freely available but can be ordered online.<ref>{{cite web | url = http://www.iso.org/iso/catalogue_detail.htm?csnumber=53682| title = ISO/IEC 9075-2:2011: Information technology -- Database languages -- SQL -- Part 2: Foundation (SQL/Foundation) }}</ref> Or you may want to refer to a working draft that you can [http://www.wiscorp.com/sql20nn.zip download] from Whitemarsh Information Systems Corporation.

{{Book Search}}
{{print version|Structured Query Language/Print version}}
{{Wikipedia|SQL}}
{{Wikiversity|SQL}}

=== Introduction ===
:[[/About the Book/]]
:[[/Database Management Systems (DBMS)/]]
:[[/Relational DBMS (rDBMS)/]]
:[[/SQL: A Language for Working with rDBMS/]]
:[[/SQL: The Standard ISO IEC 9075 and various Implementations/]]
:[[/Language Elements/]]
:[[/Learning by Doing/]]

=== The Snippets Corner [[File:BBC Snippets screeenshot 5.jpg|40px|Take a snippet]] ===
:[[/Snippets|SELECT code FROM examples WHERE topic = ...]]

=== Foundation ===
:[[/Create a simple Table|Create a simple Table]]
:[[/Handle Data|Handle Data]]
:[[/Example Database Structure|Example Database Structure]]
:[[/Example Database Data|Example Database Data]]

=== Data Query Language ===
:[[/SELECT: Fundamentals|SELECT Fundamentals]]
::[[/SELECT: Join Operation|Join Operation]]
::[[/SELECT: Grouping|Grouping]]
::[[/SELECT: IS NULL Predicate|IS NULL Predicate]]
::[[/SELECT: Predefined Functions|Predefined Functions]]
::[[/SELECT: Set Operations|Set Operations]]
::[[/SELECT: Case Expression|Case Expression]]
::[[/SELECT: Subquery|Subquery]]
:[[/Views|Views]]

=== Data Manipulation Language ===
:[[/INSERT 1|INSERT]]
:[[/INSERT 2|INSERT, using Subqueries]]
:[[/UPDATE 1|UPDATE]]
:[[/UPDATE 2|UPDATE, using Subqueries]]
:[[/DELETE 1|DELETE]]
:[[/DELETE 2|DELETE, using Subqueries]]
:[[/MERGE|MERGE]]
:[[/TRUNCATE|TRUNCATE]]
:[[/COMMIT and ROLLBACK|COMMIT and ROLLBACK]]

=== Data Definition Language ===
:[[/Create Table|CREATE TABLE]]
:[[/Data Types|Data Types]]
:[[/Foreign Key|Foreign Key]]
:[[/Alter Table|Alter Table]]
:[[/Drop Table|Drop Table]]
:[[/Temporary Table|Temporary Table]]
:[[/Managing Indexes|Indexes]]

=== Data Control Language ===
:[[/Managing Rights|Managing Rights (GRANT / REVOKE)]]

=== Advanced Topics ===
:Additional SELECT features
::[[/Like Predicate|Pattern Matching (LIKE Predicate and much more)]]
::[[/Quantified Comparison|IN, SOME/ANY, ALL, EXISTS]]
::[[/Rollup Cube|Advanced Grouping: Rollup / Cube]]
::[[/Window functions|Window functions (Data Warehouses, OLAP)]]
::[[/with clause|With Clause (Common Table Expression CTE)]]
::[[/Recursions|Recursions]]
::[[/NULLs and the Three Valued Logic|NULLs and the Three Valued Logic]]
:[[/Transactions|Transactions / Isolation Levels]]
:Some Notes on typical SQL (non-trivial) Tasks
::[[/Retrieve Top N Rows per Group|Retrieve Top N Rows per Group]]
::[[/Eliminate Duplicates|Eliminate Duplicates]]

=== Appendices ===
: [[/SQLSTATE|Warnings and Exceptions (SQLSTATE)]]
: [[/Glossary/]]

=== References ===
{{reflist}}

=== See also ===
* Wikibook [[Microsoft SQL Server]]
* Wikibook [[MySQL]]
* Wikibook [[Oracle Database]]
* Wikibook [[PostgreSQL]]
* Wikibook [[SQLite]]
* [[w:SQL reserved words|Wikipedia: SQL Key Words]]

{{shelves|SQL}}
{{Alphabetical|S}}
{{Status|100%}}

Templates used on this page:

Department:Computer programming (edit)
Department:Computer programming languages (edit)
Department:Computer science (edit)
Department:Computer software (edit)
Department:Computing (view source) (semi-protected)
Department:Database management systems (edit)
Shelf:SQL (view source) (semi-protected)
Shelf:SQL/ancestry (edit)
Structured Query Language (edit)
Template:(( (view source) (protected)
Template:)) (view source) (protected)
Template:Allbooks category (view source) (semi-protected)
Template:Alphabetical (view source) (protected)
Template:Audio (edit)
Template:BOOKCATEGORY (view source) (protected)
Template:BOOKNAME (view source) (protected)
Template:BOOKNAME/core (view source) (protected)
Template:BOOKNAME/inbook (view source) (protected)
Template:BOOKPAGENAME (view source) (protected)
Template:BOOKPAGENAME/core (view source) (protected)
Template:BOOKPAGENAME/inbook (view source) (protected)
Template:Book Search (edit)
Template:Book search (view source) (semi-protected)
Template:Cite web (edit)
Template:Department:Page (view source) (protected)
Template:Department:Page? (view source) (protected)
Template:Department:Reserved (view source) (protected)
Template:Department:Reserved/default (view source) (semi-protected)
Template:Evalx (view source) (protected)
Template:Existlist (view source) (semi-protected)
Template:Main other (view source) (protected)
Template:Mbox-side (view source) (protected)
Template:NAIVEBOOKNAME (view source) (protected)
Template:Parsable (view source) (semi-protected)
Template:Print version (view source) (protected)
Template:Px (view source) (protected)
Template:Reflist (edit)
Template:Reflist/styles.css (edit)
Template:Sec link/relative url (view source) (protected)
Template:Sec link/text (view source) (protected)
Template:Sec link auto (view source) (protected)
Template:Shelf:Ancestry (view source) (protected)
Template:Shelf:Ancestry? (view source) (protected)
Template:Shelf:Map (view source) (protected)
Template:Shelf:Nonempty list? (view source) (protected)
Template:Shelf:Page (view source) (protected)
Template:Shelf:Page? (view source) (protected)
Template:Shelves (view source) (protected)
Template:Shelves/ancestor (view source) (protected)
Template:Shelves/leaf (view source) (protected)
Template:Shelves/leaf2 (view source) (protected)
Template:Status (view source) (protected)
Template:Subject page (view source) (semi-protected)
Template:Subjects (view source) (protected)
Template:Subjects/0 (view source) (protected)
Template:Subjects/1 (view source) (protected)
Template:Subjects/2 (view source) (protected)
Template:Subjects/3 (view source) (protected)
Template:Subjects/4 (view source) (protected)
Template:Subjects/5 (view source) (protected)
Template:Subjects/allbooks (view source) (protected)
Template:Subjects/leaf (view source) (protected)
Template:Subjects/name next (view source) (protected)
Template:Wikipedia (view source) (semi-protected)
Template:Wikiversity (view source) (protected)
Category:Subject:Books by subject/all books (edit)
Category:Subject:Computer programming/all books (edit)
Category:Subject:Computer programming languages/all books (edit)
Category:Subject:Computer science/all books (edit)
Category:Subject:Computer software/all books (edit)
Category:Subject:Computing/all books (edit)
Category:Subject:Database management systems/all books (edit)
Category:Subject:SQL/all books (edit)
Subject:Books by subject (view source) (semi-protected)
Subject:Computer programming (view source) (semi-protected)
Subject:Computer programming languages (view source) (semi-protected)
Subject:Computer science (view source) (semi-protected)
Subject:Computer software (view source) (semi-protected)
Subject:Computing (view source) (semi-protected)
Subject:Database management systems (view source) (semi-protected)
Subject:SQL (view source) (semi-protected)
Module:Check for unknown parameters (edit)
Module:Citation/CS1 (edit)
Module:Citation/CS1/COinS (edit)
Module:Citation/CS1/Configuration (edit)
Module:Citation/CS1/Date validation (edit)
Module:Citation/CS1/Identifiers (edit)
Module:Citation/CS1/Utilities (edit)
Module:Citation/CS1/Whitelist (edit)
Module:Citation/CS1/styles.css (edit)
Module:TScope (view source) (protected)
Module:Wikilisp (view source) (protected)

Return to Structured Query Language.

Retrieved from "https://en.wikibooks.org/wiki/Structured_Query_Language"