Skip to main content
O'Reilly home
    • Sign In
    • Try Now
    • Teams
    • Individuals
    • Features
      • Certifications
      • Interactive learning
      • Live online sessions
    • What’s New
    • O’Reilly for marketers

Sams Teach Yourself SQL™ in 10 Minutes, Third Edition by

Get Sams Teach Yourself SQL™ in 10 Minutes, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.

Start your free trial

Contents

Introduction

1. Understanding SQL

Database Basics

What Is SQL?

Try It Yourself

Summary

2. Retrieving Data

The SELECT Statement

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Summary

3. Sorting Retrieved Data

Sorting Data

Sorting by Multiple Columns

Sorting by Column Position

Specifying Sort Direction

Summary

4. Filtering Data

Using the WHERE Clause

The WHERE Clause Operators

Summary

5. Advanced Data Filtering

Combining WHERE Clauses

Using the IN Operator

Using the NOT Operator

Summary

6. Using Wildcard Filtering

Using the LIKE Operator

Tips for Using Wildcards

Summary

7. Creating Calculated Fields

Understanding Calculated Fields

Concatenating Fields

Performing Mathematical Calculations

Summary

8. Using ...

Get Sams Teach Yourself SQL™ in 10 Minutes, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.

Start your free trial

About O’Reilly

  • Teach/write/train
  • Careers
  • Community partners
  • Affiliate program
  • Diversity

Support

  • Contact us
  • Newsletters
  • Privacy policy
facebook-logo linkedin-logo youtube-logo

Download the O’Reilly App

Apple app store Google play store

Take O’Reilly online learning with you and learn anywhere, anytime on your phone and tablet.

  • Get unlimited access to books, videos, and live training.
  • Sync all your devices and never lose your place.
  • Learn even when there’s no signal with offline access.

Do not sell my personal information

Exercise your consumer rights by contacting us at donotsell@oreilly.com.

O'Reilly home

© 2021, O’Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.

Terms of service • Privacy policy • Editorial independence