SQL> create table t_group(a int,b int);
Table created
SQL> insert into t_group values(null,1);
1 row inserted
SQL> insert into t_group values(null,2);
1 row inserted
SQL> insert into t_group values(1,2);
1 row inserted
SQL> insert into t_group values(3,2);
1 row inserted
SQL> commit;
Commit complete
SQL> select * from t_group;
A B
--------------------------------------- ---------------------------------------
1
2
1 2
3 2
--------------------------------------- ---------------------------------------
1
2
1 2
3 2
SQL> select a,count(b) from t_group group by a;
A COUNT(B)
--------------------------------------- ----------
2
1 1
3 1
--------------------------------------- ----------
2
1 1
3 1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-751370/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-751370/