MYSQL和SQL查询语句大全

来源：互联网发布：搜索引擎优化平台编辑：程序博客网时间：2024/05/03 12:40

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.csdn.net/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;