如:
name addr soct
a aa 60
a a1 50
b bb 60
b b1 65
b b3 70
要显示出来的是:
a 2
b 3
即是说name相同记录的有a,b 分别有2,3条 相同的记录.
select name ,count(name) from tablename group by name
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>