MYSQL和SQL查询语句大全-优快云博客

本文详细介绍了如何使用SQL查询语句进行日期范围内的数据筛选，包括基本查询方法、MySQL特有语法以及分组统计等高级应用。通过实例演示了如何在不同数据库环境下高效地查询特定时间段的数据。

SQL 数据库查询：

起始时间------------终止时间查询

楼主的问题说的不是很明白假如你想查找2000-02-04与2000-03-05之间的时间段有没有纪录的话
select count(*) from book where to_char(starttime,'yyyy-mm-dd')> to_char(2000-02-04,'yyyy-mm-dd') and where to_char(endtime,'yyyy-mm-dd')> to_char(2000-03-05,'yyyy-mm-dd')
Top

7 楼things（Loving You）回复于 2003-03-28 21:43:14 得分 0 select   count(*)
      from   book
    where   to_char(starttime,   'yyyy/mm/dd')   >=   to_char('起始时间',   'yyyy/mm/dd')
--       and   to_char(starttime,   'yyyy/mm/dd')   <=   to_char('终止时间',   'yyyy/mm/dd')
--       and   to_char(endtime,   'yyyy/mm/dd')   >=   to_char('起始时间',   'yyyy/mm/dd')
        and   to_char(endtime,   'yyyy/mm/dd')   <=   to_char('终止时间',   'yyyy/mm/dd')
MYSQL 查询

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
起始时间------------终止时间查询
SELECT * FROM `user` u where birthday between '2008-06-20' and '2008-06-23';

SQL
数据库中有日期按照月查询（http://topic.youkuaiyun.com/t/20021223/15/1291862.html#）

select   (case   month(date)   when   1   then   sum(money)   end)   as   一月,
                (case   month(date)   when   2   then   sum(money)   end)   as   二月,
                (case   month(date)   when   3   then   sum(money)   end)   as   三月,
                  ...
from   tblname

group   by   month(date)

MYSQL 数据库中有日期按照月查询

SELECT * FROM `user` u where month(表中日期参数)=1;

SELECT count(*) FROM dwhx where pjmc='缴费票据';

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MYSQL求总记录条数（从表dwhx按照满足PJMC=“缴费票据”）

SELECT count(*)FROM pj.dwhx where pjmc='缴费票据';

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MYSQL求满足每个条件某字段的本数（从表dwhx查询PJMC=“'缴费票据” 记录的所有一共的本数）

SELECT sum(pjbs) FROM pj.dwhx where pjmc='缴费票据';

分组统计方法：

SELECT pjmc,sum(pjbs)FROM pj.dwhx GROUP BY pjmc;