sql or and and together code example

Example 1: sql or

Used alongside WHERE to include data when either condition is true.
Example: Returns users that live in either Sheffield or Manchester.
SELECT * FROM users
WHERE city = 'Sheffield' OR 'Manchester';

Example 2: where sql multiple conditions

SELECT *
FROM suppliers
WHERE (state = 'California' AND supplier_id <> 900)
OR (supplier_id = 100);

Example 3: sql and

Used to join separate conditions within a WHERE clause.
Example: Returns events located in London, United Kingdom
SELECT * FROM events
WHERE host_country='United Kingdom' AND host_
city='London';

Tags:

Sql Example

Related