Skip to content

Instantly share code, notes, and snippets.

@robinfang

robinfang/checkdataset.sql

Created November 5, 2014 01:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save robinfang/0c3ee9cdc1d3ad02065a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save robinfang/0c3ee9cdc1d3ad02065a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
checkdataset.sql
select c from (SELECT count(*) as c, weibo.uid FROM demo.weibo join user on weibo.uid = user.uid group by weibo.uid order by c desc) as temp where c > 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment