SQL SELECT Statement

This chapter will explain the SELECT and the SELECT * statements.

The SQL SELECT Statement

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

The result is stored in a result table, called the result-set.

SQL SELECT Syntax

SELECT column_name(s)
FROM table_name
and

SELECT * FROM table_name
 Note: SQL is not case sensitive. SELECT is the same as select.

SQL Syntax

Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.

Below is an example of a table called "Persons":

P_Id        Last Name          First Name            Address                City

1               Hansen                  Ola                 Timoteivn10              Sandnes

2               Svendson                Tove                   Borgvn 23                Sandnes

3                 Pettersen                 Kari                  Storgt 20                  Stavanger

The table above contains three records (one for each person) and five columns (P_Id, LastName, FirstName, Address, and City).

SQL Statements

Most of the actions you need to perform on a database are done with SQL statements.

The following SQL statement will select all the records in the "Persons" table:

SELECT * FROM Persons
In this tutorial we will teach you all about the different SQL statements.


Keep in Mind That...