SQL Where Keyword

Now let say we want to filter out certain information, we can use the WHERE keyword to filter out the specific records. The result will then return all the records where the conditional criteria have met. For example if we want to retrieve all the student records who paid their course fees over a $1000, then we can use the WHERE keyword.

SYNTAX:

SELECT "column_name"
FROM "table_name"
WHERE "condition"

Table: Student

StudentID	LastName	FirstName	DOB	CourseFees
1	John	Astone	07/15/1976	1000.00
2	Bob	Eastwood	02/13/1935	1500.00
3	Jane	Hollywood	03/23/1939	2000.00
4	Bob	Eastwood	03/19/1980	3000.00

This examples will show you how to retrieve all the records where all student paid their course fees over $1000.00.

SELECT * FROM Student WHERE CourseFees > 1000.00

RESULT: