|
Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006
How about -- [SQL orders statistics on the number of tables for each item plots ah?
Among the items plots how to use SQL commands to the statistics on the frequency of each table?
Such as :
0
0
0
1
1
2
3
3
4
4
4
4
Results :
0 3
1 2
2 1
3 2
4 4
Thank you! !
|
Select Salinas, sum (*) from tablea group by cola; |
Thank you! Good! |
Should be :
Select Salinas, count (*) from tablea group by Salinas
|
Sum? count! |
| |