Anonymous user
JeopardyDatabase: Difference between revisions
→3. Top 20 Jeopardy categories
imported>Adamf |
imported>Adamf |
||
Line 277:
An example of using <code>GROUP BY</code> and <code>ORDER BY</code> to produce an ordered list of counts on a hypothetical <code>foo</code> field is:
<pre>SELECT foo, COUNT(foo) AS count FROM my_table GROUP BY foo ORDER BY count;</pre>
<b>Example output</b>:
| |||