WHERE语句可用于对SELECT语句中的数据进行筛选。
语法
SELECT [ ALL | DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ];
示例
- 测试数据
Address City Oxford Street Beijing Fifth Avenue Beijing Changan Street shanghai - 测试语句
SELECT * FROM XXXX WHERE City='Beijing';
- 测试结果
Address City Oxford Street Beijing Fifth Avenue Beijing