WHERE
The WHERE clause is used to filter records based on a condition. The following SQL statement will return a table that only contains rows where the "StartingMedianSalary" is greater than 60000.
You can use the following operators for the comparison.
Operator
Description
=
Equal
<>
Not equal.
>
Greater than
<
Less than
>=
Greater than or equal
<=
Less than or equal
Last updated