1.15. SQL Gotchas

Contents:

• 1.15.1. SQL gotchas
  • 1.15.1.1. Respect your LIMITS
    • 1.15.1.1.1. Using Limits with Joins
    • 1.15.1.1.2. Inline Views
  • 1.15.1.2. Make your JOINs work for you not against you
  • 1.15.1.3. ORDER BY Trick
  • 1.15.1.4. Learning more about SQL