实例 PostgreSQL 使用 AND 运算符实例

 
SELECT * FROM cars
WHERE brand = 'Volvo' AND year = 1968;        
                    

输出结果

 brand | model | year
-------+-------+------
 Volvo | p1800 | 1968
(1 row)