5.2 Assignment

SQL Server Code

1. Provide an example of a multi-table join. 

  • Present the SQL Server code and describe its purpose. 
    • When would it be appropriate to use? 
    • The example can be one you develop from scratch, use at your employment, or have located from some other source. 
    • However, the code must be in Microsoft SQL server; please do not reference other DBMS Software.

If you cite an example from another source, please list your reference. 

2. Provide an example of a query that uses a sub-query.

  • Present the SQL Server code and describe its purpose. 
    • When would it be appropriate to use? 
    • The example can be one you develop from scratch, use at your employment, or have located from some other source. 
    • However, the code must be in Microsoft SQL server; please do not reference other DBMS Software.

If you cite an example from another source, please list your reference.

error: Content is protected !!
whatsApp Us
Let's Chat, We are Here
Welcome to Hive Writers. How can we be of assistance?