Skip to content

Instantly share code, notes, and snippets.

@mustafaakin
Created February 27, 2018 10:38
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save mustafaakin/52aef845ebf32b6e311cdc04d7c268df to your computer and use it in GitHub Desktop.
SELECT destinationaddress,
SUM(bytes) AS totalBytes
FROM flows TABLESAMPLE SYSTEM (10)
GROUP BY destinationaddress
ORDER BY totalBytes DESC LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment