JeopardyDatabase: Difference between revisions
Content added Content deleted
imported>Adamf |
imported>Adamf |
||
Line 277: | 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: |
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> |
<pre>SELECT foo, COUNT(foo) AS count FROM my_table GROUP BY foo ORDER BY count;</pre> |
||
<b>Example output</b>: |
<b>Example output</b>: |