As you’ve worked through the construction of the Internet Joke
Database website, you’ve had opportunities to explore most aspects of
Structured Query Language (SQL). From the basic form of a
TABLE query to the two syntaxes of
queries, you probably know many of these commands by heart now.
In an effort to tie up some loose ends in this chapter, we’ll look at
a few more SQL tricks that we’ve yet to come across—some having been a bit
too advanced to delve into before now. As is typical, most of these will
expand on your knowledge of what’s already the most complex and potentially
confusing SQL command available to you: the
Long lists of information are always ...