更新时间:2016-05-10 21:26:33浏览次数:1+次
create table MyTable
(
ColA int,
ColB char(20),
ColC int
);
然后,我们在这个表里面插入数据:insert into MyTable values
(NULL, NULL, NULL),
(NULL, NULL, NULL),
(1,'abc',1),
(1,'def',1),
(1,'ghi',1),
(2,'jkl',1),
(2,'mno',1);
下面,我们利用select语句结合group by命令来做个示例:select ColA, COUNT(ColB) AS ColbCount,SUM(ColC) as ColCSum from MyTable group by ColA;
下面,我们来看看实现:select ColA, COUNT(ColB) AS ColbCount,SUM(ColC) as ColCSum from MyTable
group by ColA order by COUNT(ColB);
运行结果:select ColA, COUNT(ColB) AS ColbCount,SUM(ColC) as ColCSum from MyTable
group by ColA order by COUNT(ColB) desc;--Access中不可以使用“order by 数量之和 desc”
相关资讯