Home Get the count of client_mac using group by mac_address and print the same against their client_mac
Reply: 0

Get the count of client_mac using group by mac_address and print the same against their client_mac

user9361577
1#
user9361577 Published in 2018-02-14 18:33:21Z

Suppose i have 4 client_mac as below:

Mac_address client_mac

1 Qwerty123

2 safahj123

1 teyeueu23

2 wertyuu23

1 Wtdudndi

Count(client_mac) group by mac_address will be

1 3

2 2

I want to output as below:

Mac_address client_mac count

1 Qwerty123 3

2 safahj123 2

1 teyeueu23 3

2 wertyuu23 2

1 Wtdudndi 3

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.300041 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO