本文深入探讨了SQL查询中使用between、and等关键字的高级应用，包括日期比较、分数范围和日期区间匹配，同时展示了如何在项目管理中利用SQL进行日期筛选与数据统计。
select * from betweenAndTest where birthDay= str_to_date(20120401,'%Y%m%d');
select * from betweenAndTest where score between 80 and 100 AND
age BETWEEN 5 AND 20;
select * from project_jyouhou where STARTDAY between 20120101 and 20121231
and ENDDAY between 20120101 and 20121231
扫一扫
1802
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
