2.10. Summary

In this chapter, we have shown you how to use the basic SELECT statement and how to extract columns and rows using SELECT. We introduced the COUNT and ROWCOUNT functions, the AND, OR, and BETWEEN operators, table and column aliases, and synonyms. We also touched on the concept of nulls and have shown you how to include comments. Towards the end of the chapter, we presented some conventions for writing SQL statements and a few notes about SQL Server syntax. You will need this basic knowledge and understanding to work the forthcoming chapters.