unique

I was trying to figure out a query to count the IP addresses I had in a table, tell me how many are the same, then delete duplicates only leaving…