StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>A few examples of what should come to your mind first if you're real <code>SQL</code> geek:</p> <ul> <li><p><a href="http://en.wikipedia.org/wiki/Bible_concordance" rel="noreferrer"><strong>Bible concordance</strong></a> is a <code>FULLTEXT</code> index to the <code>Bible</code></p></li> <li><p><a href="http://en.wikipedia.org/wiki/Luca_Pacioli" rel="noreferrer"><strong>Luca Pacioli</strong></a>'s <em>Summa de arithmetica</em> which describes double-entry bookkeeping is in fact a normalized database schema</p></li> <li><p>When <code>Xerxes I</code> counted his army by walling an area that <code>10,000</code> of his men occupied and then marching the other men through this enclosure, he used <code>HASH AGGREGATE</code> method.</p></li> <li><p><code>The House That Jack Built</code> should be rewritten using a self-join.</p></li> <li><p><code>The Twelve Days of Christmas</code> should be rewritten using a self-join and a <code>ROWNUM</code></p></li> <li><p><code>There Was An Old Woman Who Swallowed a Fly</code> should be rewritten using <code>CTE</code>'s</p></li> <li><p>If the <code>European Union</code> were called <code>European Union All</code>, we would see <code>27</code> spellings for the word <code>euro</code> on a <a href="http://en.wikipedia.org/wiki/File:EUR_500_reverse_(2002_issue).jpg" rel="noreferrer"><strong>Euro banknote</strong></a>, instead of <code>2</code>.</p></li> </ul> <p>And finally you can read a lame article in my blog on how <em>I</em> stopped worrying and learned to love <code>SQL</code> (I almost forgot I wrote it):</p> <ul> <li><a href="http://explainextended.com/2009/06/21/click/" rel="noreferrer"><strong>Click</strong></a></li> </ul> <p>And one more article just on the subject:</p> <ul> <li><a href="http://explainextended.com/2009/07/12/double-thinking-in-sql/" rel="noreferrer"><strong>Double-thinking in SQL</strong></a></li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload