Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

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!



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com