AND运算符#
语法##
SELECT column1, column2, columnN
FROM table_name
WHERE [condition1] AND [condition2] AND [conditionN]
实例##
实例
SELECT * FROM COMPANY WHERE AGE >= 25 AND SALARY >= 65000;
OR运算符#
语法##
SELECT column1, column2, columnN
FROM table_name
WHERE [condition1] OR [condition2] ... OR [conditionN]
实例##
实例
SELECT * FROM COMPANY WHERE AGE >= 25 OR SALARY >= 65000;
