SQL - Operators in The WHERE Clause

The following operators can be used in the WHERE clause: OperatorDescription =Equal <>Not equal. >Greater than <Less than >=Greater...

SQL - Text Fields vs. Numeric Fields

SQL requires single quotes around text values (most database systems will also allow double quotes). However, numeric fields should not be enclosed...

SQL - WHERE Clause Example

The following SQL statement selects all the customers from the country "Mexico", in the "Customers" table: Example SELECT * FROM CustomersWHERE Country='Mexico'; Try...

SQL - SELECT DISTINCT Example

The following SQL statement selects only the distinct values from the "City" columns from the "Customers" table: Example SELECT DISTINCT City FROM Customers; Try...