Skip to content

Instantly share code, notes, and snippets.

@songyunlu
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.
/* 執行時間: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