Link to home
Start Free TrialLog in
Avatar of beridius
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

Open in new window

would count as 3
ASKER CERTIFIED SOLUTION
Avatar of Meir Rivkin
Meir Rivkin
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of beridius
beridius

ASKER

i will give that a go thanks
thanks that works