Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Get to know the database
Basic revenue metrics
Summary
15. Summary

Instruction

Perfect! That's it for this part of the course. Let's have a short summary before we continue.

  1. To find rows for three weeks starting from March 20, 2017, use:
    SELECT ...
    FROM ...
    WHERE ColumnName >= '20170320' AND ColumnName < DATEADD(Week, 3, '20170320')
  2. To find rows for the current month, use:
    SELECT ...
    FROM ...
    WHERE ColumnName >= DATEADD(Month, DATEDIFF(Month, 0, GETDATE()), 0)

Okay, let's do a very short quiz before we conclude this part.

Exercise

Click Next exercise to continue.