Microsoft® SQL Server® 2012 Step by Step

Chapter 10. The SELECT statement

After completing this chapter, you will be able to

• Write a SELECT statement.

• Sort your results.

• Filter a SELECT statement with the WHERE clause.

• Use comparison operators.

• Use the BETWEEN operator.

• Use the WHERE clause with multiple conditions.

• Search for a list of values.

• Use a wildcard search.

• Create aliases.

• Use the JOIN operator.

• Limit the data returned in your result set.

• Use the UNION keyword to combine result sets.

So far in this book, you have learned how to create databases and tables, but what happens after an application has added data to the database? How do you get the data out? Microsoft SQL Server data retrieval is a very straightforward and simple process. To retrieve or access data inside a SQL Server database, ...