PostgreSQL AND&OR條件在僅一個查詢中提供了AND和OR條件的優(yōu)點。
語法:
SELECT column1, column2, ..... columnN
FROM table_name
WHERE [search_condition] AND [search_condition]
OR [search_condition];
我們來看一下表“EMPLOYEES”,具有以下數(shù)據(jù)。
查詢名字的值為Minsu和地址的值為’Delhi‘,或者ID值大于等8的記錄信息,執(zhí)行以下查詢:
SELECT *
FROM EMPLOYEES
WHERE (NAME = 'Minsu' AND ADDRESS = 'Delhi')
OR (ID>= 8);
得到以下結果 -