1.1

The Five Clauses of the SELECT Statement

The Five Clauses of the SELECT statement

  • SELECT – the columns in the result set
  • FROM – names the base table(s) from which results will be retrieved
  • WHERE – specifies any conditions for the results set (filter)
  • ORDER BY – sets how the result set will be ordered
  • LIMIT – sets the number of rows to be returned

The clauses MUST appear in the order shown above.

Code Example:1    USE world;
2    SELECT name
3    FROM city
4    WHERE CountryCode = “AFG”
5    ORDER BY name
6    LIMIT 3

Results:

Retrieve_data_from_a_single_table_example1.png

Let us break the statement line by line:

USE world;

SELECT name

FROM city

ORDER BY name

LIMIT 5;

Table 1. Column Specifications

Source Option Syntax

Base Table Value

Show all columns

 

Base Table Value

Column Name

Comma-separated list of column names

Calculated Value

Calculation result

Arithmetic expression

Calculated Value

Calculation result

Functions

This content is provided to you freely by BYU-I Books.

Access it online or download it at https://books.byui.edu/learning_mysql/the_five_clauses_of_.