Skip to content

Instantly share code, notes, and snippets.

@songyunlu

songyunlu/GROUPBY.sql

Created March 2, 2013 07:00
Show Gist options
  • Save songyunlu/5069994 to your computer and use it in GitHub Desktop.
Save songyunlu/5069994 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
GROUPBY.sql
/* 執行時間：2.19 秒 */
SELECT phone, COUNT(*) from post GROUP BY phone LIMIT 1;
/* 執行時間：2.02秒 */
SELECT phone, COUNT(*) from post GROUP BY phone ORDER BY NULL LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment