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)