Skip to main content

The SELECT Statement

  • Chapter
  • 2714 Accesses

Abstract

You will use the SELECT statement more than any other T-SQL statement in your database career. This is an axiom that applies to DBAs as much as it does to developers. SELECT is your friend, your assistant, your sidekick. Whenever you have a question about your database, chances are SELECT will give you the answer. That said, SELECT in the wrong hands can be evil. Evil! It’s easier to make SELECT give you the wrong data than the right data (much easier, usually). Let’s see if we can keep SELECT on the side of the good guys.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Mike McQuillan

About this chapter

Cite this chapter

McQuillan, M. (2015). The SELECT Statement. In: Introducing SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1419-0_11

Download citation

Publish with us

Policies and ethics