IN
更新时间:2022-09-13 21:31:29
语法
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)
入参
功能描述
用来查找在参数中的记录。
示例
id(Int) |
LastName(Varchar) |
1 |
Adams |
2 |
Bush |
3 |
Carter |
SELECT * FROM T1
WHERE LastName IN ('Adams','Carter')
id(Int) |
LastName(Varchar) |
1 |
Adams |
3 |
Carter |