Effective SQL: 61 Specific Ways to Write Better SQL, 1st edition

Effective SQL: 61 Specific Ways to Write Better SQL

ISBN-13:  9780134578897

The hands-on, step-by-step, plain-English guide to solving complex problems with SQL

• 61 practical, easy-to-use solutions -- all in full-color, with simple explanations and no jargon!
• Designed for all leading SQL implementations, with additional techniques for widely used versions. (Tested on IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.)
• Identifies common misconceptions and pitfalls when authoring solutions using SQL and provides effective solutions to common scenarios
• Written by John Viescas (SQL Queries For Mere Mortals, 3rd Edition) and a world-renowned team of Microsoft MVPs