SQL requires single quotes around text values (most database systems will also allow double quotes).

However, numeric fields should not be enclosed in quotes:
 

Example

SELECT * FROM Customers
WHERE CustomerID=1;



Practice Excercise Practice now