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 |