where sql multiple conditions
snippet in sql

where sql multiple conditions

user1907

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

sql query with multiple where conditions

user3905

SQL> SELECT ID, NAME, SALARY 
FROM CUSTOMERS
WHERE SALARY > 2000 OR age < 25;