如果你的日期格式是yyyy-MM-dd 不包括小时分秒的话 用select count(*) as totalpeople from biao b group by b.date 如果有小时分秒的还真想不出来现在
select count(*) as totalpeople from biao b where b.date between 时间1 and 时间2 时间1 取当天的凌晨00:00:00 时间2 取当天的23:59:59
oracle下 如果日期的那个字段是varchar2类型且格式为YYYYMMDDHHMISS(下面暂时叫ROW_DATE字段) SELECT SUBSTR(ROW_DATE, 0, 8) DAY, COUNT(*) DAY_NUM FROM TABLE GROUP BY SUBSTR(ROW_DATE, 0, 8) ORDER BY SUBSTR(ROW_DATE, 0, 8) DESC如果日期的那个字段是日期类型(下面暂时叫ROW_DATE字段) SELECT SUBSTR(TO_CHAR(ROW_DATE, 'YYYYMMDD'), 0, 8) DAY, COUNT(*) DAY_NUM FROM TABLE GROUP BY SUBSTR(TO_CHAR(ROW_DATE, 'YYYYMMDD'), 0, 8) ORDER BY SUBSTR(TO_CHAR(ROW_DATE, 'YYYYMMDD'), 0, 8) DESC
select count(*) as totalpeople from biao b where b.date between 时间1 and 时间2 时间1 取当天的凌晨00:00:00 时间2 取当天的23:59:59
加个where条件 假定日期格式是yyyyMMdd hh:mm:ss where substr(date,0,6)=to_date('200809','yyyyMM') group by substr(date,0,8)
select count(*) as totalpeople from biao b where b.date between 时间1 and 时间2 时间1 取当天的凌晨00:00:00 时间2 取当天的23:59:59
select * from tableName where datediff(时间字段,getdate()) = 0其中: 时间字段对应数据库中保存今天注册的日期字段名 getdate()是系统中的函数,用来取得当前是哪一天申明:可能我写的函数名有错误,因为好久没写了。自己要仔细验证下噢 datediff()也是数据库系统中的函数,它用来计算某个日期类型的变量与当前那天的日期差,0代表是同一天
select count(*) as totalpeople from biao b where b.date between 时间1 and 时间2 时间1 取当天的凌晨00:00:00 时间2 取当天的23:59:59
用select count(*) as totalpeople from biao b group by b.date
如果有小时分秒的还真想不出来现在
时间2 取当天的23:59:59
如果日期的那个字段是varchar2类型且格式为YYYYMMDDHHMISS(下面暂时叫ROW_DATE字段)
SELECT SUBSTR(ROW_DATE, 0, 8) DAY,
COUNT(*) DAY_NUM
FROM TABLE
GROUP BY
SUBSTR(ROW_DATE, 0, 8)
ORDER BY
SUBSTR(ROW_DATE, 0, 8) DESC如果日期的那个字段是日期类型(下面暂时叫ROW_DATE字段)
SELECT SUBSTR(TO_CHAR(ROW_DATE, 'YYYYMMDD'), 0, 8) DAY,
COUNT(*) DAY_NUM
FROM TABLE
GROUP BY
SUBSTR(TO_CHAR(ROW_DATE, 'YYYYMMDD'), 0, 8)
ORDER BY
SUBSTR(TO_CHAR(ROW_DATE, 'YYYYMMDD'), 0, 8) DESC
时间2 取当天的23:59:59
where substr(date,0,6)=to_date('200809','yyyyMM')
group by substr(date,0,8)
时间2 取当天的23:59:59
时间字段对应数据库中保存今天注册的日期字段名
getdate()是系统中的函数,用来取得当前是哪一天申明:可能我写的函数名有错误,因为好久没写了。自己要仔细验证下噢
datediff()也是数据库系统中的函数,它用来计算某个日期类型的变量与当前那天的日期差,0代表是同一天
时间2 取当天的23:59:59