导入
使用 WHERE 过滤行
学习如何使用 where 子句和运算符来筛选行。
PageFlux AI 助手
💡 选中文本后点击"AI 询问"，或 Ctrl+Enter 发送消息
1SELECT first_name, last_name, department 2FROM employees 3WHERE department = 'Engineering';
PageFlux AI 助手
💡 选中文本后点击"AI 询问"，或 Ctrl+Enter 发送消息
1SELECT first_name, last_name, salary 2FROM employees 3WHERE salary > 80000;
PageFlux AI 助手
💡 选中文本后点击"AI 询问"，或 Ctrl+Enter 发送消息
1SELECT first_name, last_name, department, salary 2FROM employees 3WHERE department = 'Engineering' 4 AND salary > 80000;
1SELECT first_name, last_name, department, salary 2FROM employees 3WHERE department = 'Marketing' 4 AND salary > 60000;
表格
| 概念 | 作用 | 示例 |
|---|---|---|
| WHERE | 按条件过滤行 | WHERE salary > 80000 |
| 比较运算符 | 比较数字或文本 | =, >, >=, <, <=, != |
| AND | 两个条件都必须为真 | WHERE dept='Eng' AND salary>80000 |
| OR | 任一条件为真即可 | WHERE dept='Eng' OR dept='Marketing' |