How to Select Last Month's Records in SQL Server & MySQL скачать в хорошем качестве

How to Select Last Month's Records in SQL Server & MySQL

Here's a quick SQL query to return last month's records in SQL Server and MySQL/MariaDB. 00:00 - Introduction 00:24 - SQL Server 01:04 - Don't make this mistake! 01:50 - MySQL + MariaDB Here's what you need in SQL Server's transact-SQL: SELECT * FROM TABLE_NAME WHERE DATEPART(m, DATE_COLUMN_NAME) = DATEPART(m, DATEADD(m, -1, getdate())) AND DATEPART(year, DATE_COLUMN_NAME) = DATEPART(yy, DATEADD(m, -1, getdate())) Here's the equivalent SQL statement for MySQL and MariaDB: SELECT * FROM TABLE_NAME WHERE MONTH(DATE_COLUMN_NAME) = MONTH(DATE_ADD(NOW(), INTERVAL -1 MONTH)) AND YEAR(DATE_COLUMN_NAME) = YEAR(DATE_ADD(NOW(), INTERVAL -1 MONTH)) You can probably use something similar for PostgreSQL and other relational databases. If you use -2 in the query instead of -1 then you will find the month before last month's records. Some reporting dashboards like to include this data as well. If you're learning to code then notice how I always check the results of running the script - this is an extremely important skill for software developers. If you found this video leave a LIKE and SUBSCRIBE for more coding videos. Check out my SQL Programming playlist for more tutorials:    • SQL Programming