时间:2021-07-01 10:21:17 帮助过:2人阅读
select count(*),year(b.date),month(b.date) ,day(b.date) from person as b group by year(b.date),Month(b.date), day(b.date) order by b.date desc查询结果
select count(*),year(b.date),month(b.date) ,day(b.date) from person as b group by year(b.date),Month(b.date), day(b.date) order by b.date desc
sql语句分组统计出年月日下数据记录数目
标签:
< 上一篇
System.Data.DbType的字符串和数据库中字符串类型对应关系
下一篇 >
关于各个数据库中限制取出数据条数的简餐操作
记住我的登录 忘记密码?
登录
我已阅读用户协议及版权声明
注册