The current W3Schools page explains the SQL SELECT statement, which is used to select data from a database.

• Purpose: The SELECT statement retrieves data from one or more columns in a database table.

• Basic Syntax:

  SELECT column1, column2, ...
  FROM table_name;
  

  You can specify particular columns or use SELECT * to retrieve all columns from a table.

• Example:

  SELECT CustomerName, City
  FROM Customers;
  

  This will display CustomerName and City columns from the Customers table.

• Demo Table: The page provides a sample Customers table used in examples, showing typical columns like CustomerID, CustomerName, ContactName, Address, City, PostalCode, and Country.

• Practice: There are interactive features like a “Try it Yourself” button and a quiz question about the purpose of SELECT.

• Additional Resources: The page links to video tutorials, sample databases, and navigation for related SQL topics such as WHERE, ORDER BY, JOIN, and more.

In summary:
The SQL SELECT statement is essential for querying and fetching data from tables in a database, with clear syntax and useful practice examples provided on the page.[1]

1

SQL SELECT Statement

The SQL SELECT Statement

The SELECT statement is used to select data from a database.

Return data from the Customers table:

SELECT CustomerName, City FROM Customers;

Syntax

SELECT column1, column2, ...
FROM table_name;

Here, column1, column2, ... are the field names of the table you want to select data from.

The table_name represents the name of the table you want to select data from.

Demo Database

Below is a selection from the Customers table used in the examples:

Select ALL columns

If you want to return all columns, without specifying every column name, you can use the SELECT * syntax:

Return all the columns from the Customers table:

SELECT * FROM Customers;