Sql server® 2012 t-sql fundamentals

 

CHAPTER 2

 

Single-Table Queries

 

 91

Conclusion

This chapter introduced you to the SELECT statement, logical query processing, and various other 

aspects of single-table queries. I covered quite a few subjects here, including many new and unique 

concepts. If you’re new to T-SQL, you might feel overwhelmed at this point. But remember, this 

chapter introduces some of the most important points about SQL that might be hard to digest at the 

beginning. If some of the concepts weren’t completely clear, you might want to revisit sections from 

this chapter later on, after you’ve had a chance to sleep on it.

For an opportunity to practice what you’ve learned and absorb the material better, I recommend 

going over the chapter exercises.

Exercises

This section provides exercises to help you familiarize yourself with the subjects discussed in Chapter 2. 

Solutions to the exercises appear in the section that follows. 

You can find instructions for downloading and installing the TSQL2012 sample database in the 

Appendix.

1

Write a query against the Sales.Orders table that returns orders placed in June 2007.

■

■

Tables involved: TSQL2012 database and the Sales.Orders table

■

■

Desired output (abbreviated):

orderid     orderdate               custid      empid 

----------- ----------------------- ----------- ----------- 

10555       2007-06-02 00:00:00.000 71          6 

10556       2007-06-03 00:00:00.000 73          2 

10557       2007-06-03 00:00:00.000 44          9 

10558       2007-06-04 00:00:00.000 4           1 

10559       2007-06-05 00:00:00.000 7           6 

10560       2007-06-06 00:00:00.000 25          8 

10561       2007-06-06 00:00:00.000 24          2 

10562       2007-06-09 00:00:00.000 66          1 

10563       2007-06-10 00:00:00.000 67          2 

10564       2007-06-10 00:00:00.000 65          4 

... 

 

(30 row(s) affected)

www.it-ebooks.info

---