SELECT TOP 1000 [OrderID] ,[CustomerID] ,[EmployeeID] ,[OrderDate] ,[RequiredDate] ,[ShippedDate] ,[ShipVia] ,[Freight] ,[ShipName] ,[ShipAddress] ,[ShipCity] ,[ShipRegion] ,[ShipPostalCode] ,[ShipCountry] FROM [Northwind].[dbo].[Orders] WHERE OrderDate > DATEADD(MONTH,-1,GETUTCDATE());
-
Recent Posts
- How to select last month’s entries from your database
- If you could listen to only one song today – Manfred Hubler & Siegried Schwab – The Lions & The Cucumber
- If you could listen to only one song today – Fettes Brot-Jein
- If you could listen to only one song today – Mos Def – Next Universe
- If you could listen to only one song today – Tom Jones – Thunderball
Categories