On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
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 to continue.