SQL Hacks: Write queries that won't turn to digital dust
November 20, 2006[From O'Reilly]
Sebastopol, CA--Andrew Cumming is a big fan of SQL; he says it's elegant, well designed, and phenomenally useful...but it's not always easy to use: "You can do incredibly powerful queries in just a few lines of code, but then other times you have to tie yourself in knots just to get something trivial done." With coauthor Gordon Russell, Cumming has written SQL Hacks, a collection of 100 tips and tools to help users get more from SQL's power and flexibility, and spend less time tying themselves in knots. "There are a handful of SQL 'cliches' or 'phrases' that I use all the time, but not everyone knows about them," says Cumming. "They save a lot of time and once they get under your skin, you can use them without thinking about them."
The article continues at http://press.oreilly.com/pub/pr/1651