in操作符允许我们在where子句中规定多个值。
sql in 语法
select 列名字列表 from 表名字 where 列名字 in (value1, value2,.......)
Persons 表:
Id | LastName | FirstName | Address | City |
---|---|---|---|---|
1 | Adams | John | Oxford Street | London |
2 | Bush | George | Fifth Avenue | New York |
3 | Carter | Thomas | Changan Street | Beijing |
in操作符实例
现在,我们希望从上表中选取姓氏为 Adams 和Carter的人:
select * from Persons where FirstName in ('Adams','Carte');
结果集:
Id | LastName | FirstName | Address | City |
---|---|---|---|---|
1 | Adams | John | Oxford Street | London |
3 | Carter | Thomas | Changan Street | Beijing |