i am using one database in mysql in which it is having a record of source IP(sip), destination IP(dip), source port(sport), destination Port(dport). when doing select query
(select count(sport) as port, sport from IPtable limit 20); the result is as this query states means port sport
3 | 80
5 | 8080
15 | 21
3 | 20
25 | 443
16 | 1234
49 | 2352
15 | 2353

i want to group these...