ImplementationSELECT...FROM...WHERE...clause

To go a step further, the WHERE clause can be used. The WHERE clause will only return records that meet a specific condition.

SELECT PupilID, Surname, Class

FROM Pupil

WHERE Class = ‘1T1’;

This would return

The WHERE clause has been used to ensure that the only records returned are those that have the value ‘1T1’ in the 'Class' column/field.