- "add interval to date or time [SQL Server]" - "subtract interval from date or time [SQL Server]" [!INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw ...
Query #1.4: Since we only need 1 row from the Query #1.3's output, we remove all duplicated rows using SELECT DISTINCT Statement We calculate the dates for the first day of this and next year using ...