Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table:
- c1,c2,c3
- Group1, 123.123.123.123, http://example.com
- Group1, 1.1.1.1, http://example.com
- Group1, 1.1.1.1, http://example2.com
- Group1, 123.123.123.123, http://example.com
- Group2, 2.3.4.5, http://foobar.com
- Note:
- I want to count the unique pairs for c2 and c2 and group by c1
- Output:
- Group1, 3
- Group2, 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement