6.5. Summary

In this chapter, we provided you with an overview of different derived structures available in SQL Server. Each of these derived structures has its own advantages and disadvantages, and once you have knowledge of the different derived structures, it is up to you to select the derived structure that you wish to use to make your work easier or more efficient. Oftentimes it is not easy to formulate a query all at once. The derived structures will help you formulate your queries in a more systematic step-by-step manner.