SQL count distinct subnets in an IP column

Posted by renhack on Stack Overflow See other posts from Stack Overflow or by renhack
Published on 2010-03-19T14:35:41Z Indexed on 2010/03/19 15:21 UTC
Read the original article Hit count: 136

Filed under:
|

I need to get a get a count of all the distinct subnets in an IP column and group by the subnet on MS SQL. ie.. count all ips that have a subnet of 192.168.0,192.168.1,10.10.10 and so on.

Any help is appreciated. Thanks

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server