Suchergebnisse mit Tag „groupby“

TOP

Did you know GROUP BY ... ORDER BY NULL?

Sep 07
von Sebastian am 7.09.2013 um 9:04 in mySQL

Here are three SQL queries and one simple challenge: Order them by speed assuming that city has an index.

1. SELECT city, SUM(inhabitants) FROM population GROUP BY city
2. SELECT city, SUM(inhabitants) FROM population GROUP BY city ORDER BY city
3. SELECT city, SUM(inhabitants) FROM population GROUP BY city ORDER BY city DESC
Weiterlesen
GROUP BY, MySQL, ORDER BY
Ein Kommentar