Beginning T-SQL: A Step-by-Step Approach

© Kathi Kellenberger, Lee Everest 2021

K. Kellenberger, L. EverestBeginning T-SQLhttps://doi.org/10.1007/978-1-4842-6606-9_3

3. Writing Simple SELECT Queries

Kathi Kellenberger¹   and Lee Everest²

(1)

Edwardsville, IL, USA

(2)

Euless, TX, USA

 

Chapter 1 had you prepare your computer by installing SQL Server and the sample databases. You learned how to get around in Azure Data Studio and a few tips to help make writing queries easier. In Chapter 2, you learned about databases, tables, and the other objects that make up a database.

Now that you’re ready, it’s time to learn how to retrieve data from a SQL Server database, which you will do by using the SELECT statement, starting with the simplest syntax. This chapter will cover the different parts, called ...