Advertisement
Guest User

Untitled

a guest
Jul 29th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. Table:
  2. c1,c2,c3
  3. Group1, 123.123.123.123, http://example.com
  4. Group1, 1.1.1.1, http://example.com
  5. Group1, 1.1.1.1, http://example2.com
  6. Group1, 123.123.123.123, http://example.com
  7. Group2, 2.3.4.5, http://foobar.com
  8.  
  9. Note:
  10. I want to count the unique pairs for c2 and c2 and group by c1
  11.  
  12. Output:
  13.  
  14. Group1, 3
  15. Group2, 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement