Difference between revisions of "Category:SQL"

From database24
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
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 ==
Line 41: Line 6:
  
 
== Special SQL ==
 
== Special SQL ==
* Microsoft Access OLEDB
+
* [[Microsoft Access Special Queries|Microsoft Access Queries]]
  
 
== Tools ==
 
== Tools ==

Latest revision as of 21:17, 2 September 2010

Pages in category "SQL"

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