求1数量统计的SQL语句
求一数量统计的SQL语句
select top 100 scontrino,n,data from negozio_szt group by n,data,scontrino order by data desc
得到
s n data
294 1 2014-07-08 13:50:48.000
279 1 2014-07-08 13:38:29.000
79 2 2014-07-08 11:39:14.000
14 1 2014-07-08 11:23:22.000
89 1 2014-07-08 10:35:37.000
16 1 2014-07-08 09:18:57.000
我怎么再让它统计一下每个N的总条数，得到
s n
5 1
1 2
就是把N一样的总数再加起来得到每个N下有几条记录
------解决方案--------------------
select count(*) s,n
from(
select top 100 scontrino,n,data from negozio_szt group by n,data,scontrino )a
group by n
------解决方案--------------------
select top 100 scontrino,n,data from negozio_szt group by n,data,scontrino order by data desc
得到
s n data
294 1 2014-07-08 13:50:48.000
279 1 2014-07-08 13:38:29.000
79 2 2014-07-08 11:39:14.000
14 1 2014-07-08 11:23:22.000
89 1 2014-07-08 10:35:37.000
16 1 2014-07-08 09:18:57.000
我怎么再让它统计一下每个N的总条数，得到
s n
5 1
1 2
就是把N一样的总数再加起来得到每个N下有几条记录
------解决方案--------------------
select count(*) s,n
from(
select top 100 scontrino,n,data from negozio_szt group by n,data,scontrino )a
group by n
------解决方案--------------------
select
count(1) as s,n
from(select top 100 scontrino,n,data from negozio_szt group by n,data,scontrino )as t
group by n