beridius
asked on
mysql
is there away of count the rows but exclude if the row contains the same information eg
2013-01-29 09:25:07 25 07111111111 SIP/119 1300000007.88830
2013-01-29 09:25:07 25 07111111111 SIP/119 1300000007.88830
2013-01-29 09:25:07 25 07111111111 SIP/119 1300000007.88830
2013-01-29 09:36:50 47 07222222222 SIP/119 1311111110.89099
2013-01-29 09:36:50 47 07222222222 SIP/119 1311111110.89099
2013-01-29 09:36:50 47 07222222222 SIP/119 1311111110.89099
2013-01-29 09:41:36 11 07333333333 SIP/119 1322222496.89209
2013-01-29 09:41:36 11 07333333333 SIP/119 1322222496.89209
2013-01-29 09:41:36 11 07333333333 SIP/119 1322222496.89209
2013-01-29 09:41:36 11 07333333333 SIP/119 1322222496.89209
would count as 3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks that works
ASKER