我有一个这样的表字段如下requisition_time,inpateint_id,requisition_id,charge_item_id表里的内容如下:2008-02-01,123456,23543,12
2008-02-01,123456,23543,43
2008-02-01,123456,23245,23
2008-02-01,121232,23236,65
2008-02-02,566664,23553,78
不知道怎样才能做出这样的汇总统计来,如2008-01-01 2 3 4
2008-02-02 1 1 1
能否通过存储过程来实现,谢谢。
2008-02-01,123456,23543,43
2008-02-01,123456,23245,23
2008-02-01,121232,23236,65
2008-02-02,566664,23553,78
不知道怎样才能做出这样的汇总统计来,如2008-01-01 2 3 4
2008-02-02 1 1 1
能否通过存储过程来实现,谢谢。
select requisition_time,count(distinct inpateint_id),count(distinct requisition_id),
count(distinct charge_item_id) from 表名 group by requisition_time