Skip to content

Instantly share code, notes, and snippets.

@mustafaakin
Created February 27, 2018 10:38
Show Gist options
  • Save mustafaakin/52aef845ebf32b6e311cdc04d7c268df to your computer and use it in GitHub Desktop.
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