Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2023-06-23 02:14:50 →
Size: 368
Editor: DominicRicottone
Comment:
← Revision 2 as of 2023-06-23 03:08:13 → ⇥
Size: 369
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 20: Line 20:
The `WHERE` clause accepts any [[SQL/Expression|expression]]. The `WHERE` clause accepts any [[SQL/Expressions|expression]].

SQL Select

The SELECT statement subsets the data of a table.

Contents

  1. SQL Select
    1. Usage

Usage

SELECT col1, col2, col3 FROM table;
SELECT col1, col2, col3 FROM table WHERE col4=1;

To keep all columns, specify a star (*).

The WHERE clause accepts any expression.

CategoryRicottone

SQL/Select (last edited 2023-06-23 03:08:13 by DominicRicottone)