Difference between revisions of "Category:SQL"

From database24
Jump to navigation Jump to search
Line 1: Line 1:
 
== Basics ==
 
== Basics ==
 
+
* [[SQL]]
=== Select ===
 
The SELECT statement is used to assemble fields of different tables and queries to a new result.
 
 
 
==== Examples ====
 
* Selecting all fields from a table
 
<syntaxhighlight lang=SQL>
 
SELECT *
 
  FROM tbl
 
</syntaxhighlight>
 
 
 
* Selecting two fields from a table
 
<syntaxhighlight lang=SQL>
 
SELECT field1
 
    , field2
 
  FROM tbl
 
</syntaxhighlight>
 
 
 
 
 
=== Insert ===
 
* INSERT INTO
 
 
 
=== Update ===
 
* UPDATE
 
 
 
=== Delete ===
 
* DELETE
 
 
 
 
 
== Joins ==
 
 
 
 
 
== Distinct ==
 
 
 
 
 
== Sub Select ==
 
  
 
== Formatting ==
 
== Formatting ==

Revision as of 17:10, 22 July 2010

Basics

Formatting

Special SQL

  • Microsoft Access OLEDB

Tools

Pages in category "SQL"

The following 5 pages are in this category, out of 5 total.