WHERE clause is used to filter records.
1SELECT column1, column2, ...
2FROM table_name
3WHERE condition;
4
5UPDATE table_name
6SET column1 = value1, column2 = value2, ...
7WHERE condition;
8
9INSERT INTO table_name (column1, column2, ...)
10VALUES (value1, valu2, ...)
11WHERE condition;
Sample Database
| Id |
FullName |
Title |
Department |
Manager |
| 1 |
Eric Brown |
Software Engineer |
IT |
Frank Martin |
| 2 |
Brandon Hart |
DevOps Engineer |
IT |
Justin Martin |
| 3 |
Connor Langdon |
Software Engineer |
IT |
Lucas Scott |
| 4 |
James Murray |
Test Automation Engineer |
IT |
Frank Martin |
| 5 |
Leonard Smith |
Software Engineer |
IT |
Frank Roberts |
Examples / Outputs
1SELECT * FROM Engineer
2WHERE FullName='Eric Brown';
3
4SELECT * FROM Engineer
5WHERE Id=1;
| Id |
FullName |
Title |
Department |
Manager |
| 1 |
Eric Brown |
Software Engineer |
IT |
Frank Martin |
WHERE Clause Operators
| Operator |
Description |
| = |
Equal |
| > |
Greater than |
| < |
Less than |
| >= |
Greater than or equal |
| <= |
Less than or equal |
| <> |
Not equal. Note: In some versions of SQL this operator may be written as != |
| BETWEEN |
Between a certain range |
| LIKE |
Search for a pattern |
| IN |
To specify multiple possible values for a column |