PostgreSQL AND & OR
AND / OR 组合多个条件,括号可控制优先级。
Key PointsPostgreSQL,AND,OR,逻辑条件
讲解
AND / OR 组合多个条件,括号可控制优先级。
示例
SQL
SELECT * FROM company
WHERE age > 25 AND salary > 0;
SELECT * FROM company
WHERE age < 25 OR salary IS NULL;讲解
AND / OR 组合多个条件,括号可控制优先级。
示例
SQL
SELECT * FROM company
WHERE age > 25 AND salary > 0;
SELECT * FROM company
WHERE age < 25 OR salary IS NULL;