Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Revenue Trend Analysis in SQL Server

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.