ImplementationSELECT…FROM… statement

The select statement is used to select data from the database.

To select all the records from a table, the following command is used (where Table_Name would be replaced by the name of the table in the database):

SELECT * FROM Table_Name;

If the table were named 'Pupil' then the command would read:

SELECT * FROM Pupil;

All records in the pupil table would be returned. The asterisk * is used to return all data found in the table.

To aid understanding of the remaining examples, here is the data held in the pupil table.

The following SQL command could be used to select specific data from the table:

SELECT PupilID, Surname, Class FROM Pupil;

This would return: