Skip to content

Instantly share code, notes, and snippets.

@sAbakumoff

sAbakumoff/arrange_duplicate_data.sql

Created August 16, 2016 13:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sAbakumoff/20aa371d4cb1a82c3812aed138f9c6c4 to your computer and use it in GitHub Desktop.
Save sAbakumoff/20aa371d4cb1a82c3812aed138f9c6c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
arrange_duplicate_data.sql
SELECT
id,
FIRST(name) AS repo_name,
FIRST(copies) AS num_of_copies
FROM
[githubdataqueries:NpmStat.package_json_duplicates]
GROUP BY
id
ORDER BY
num_of_copies DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment