数据库开发及ADO.NET(15)——多值匹配

最新推荐文章于 2021-07-13 18:01:37 发布

陆老师Peter

最新推荐文章于 2021-07-13 18:01:37 发布

阅读量117

点赞数

分类专栏： SQL ADO.NET 文章标签： in AND BETWEEN AND 集合

本文链接：https://blog.csdn.net/qq_34573534/article/details/100168415

版权

SQL 同时被 2 个专栏收录

83 篇文章 4 订阅

订阅专栏

ADO.NET

66 篇文章 1 订阅

订阅专栏

1、要删除多条记录怎么办？in 表示一个集合。

（1）Delete T_Employee where FId in (21,22)

（2）SELECT FAge,FNumber,FName FROM T_Employee WHERE FAge IN (23,25,28)

2、范围值：

（1）SELECT * FROM T_Employee WHERE FAGE>=23 AND FAGE <=27

（2）SELECT * FROM T_Employee WHERE FAGE BETWEEN 23 AND 27

3、例：

select null+1

select 'abc'+'123'

select ''+'123'

select null+'123'

select * from T_Employee
where FName<>null

select * from T_Employee
where FName is null;

select * from T_Employee
where FName is not null;

select * from T_Employee
where FAge=23 or FAge=25 or FAge=28

select * from T_Employee
where FAge in (23,25,28)

select * from T_Employee
where FAge>20 and FAge<30

select * from T_Employee
where FAge between 20 and 30