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