विशिष्ट महीने और वर्ष के रिकॉर्ड प्रदर्शित करने के लिए क्रमशः YEAR() और MONTH() फ़ंक्शन का उपयोग करें। आइए पहले एक टेबल बनाते हैं:
mysql> CREATE TABLE DemoTable (
CustomerId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
CustomerName VARCHAR(20),
CustomerTotalBill INT,
PurchasingDate DATE
);
टेबल में कुछ रिकॉर्ड डालें:
mysql> INSERT INTO DemoTable(CustomerName, CustomerTotalBill, PurchasingDate) VALUES('John', 2000, '2019-01-21');
mysql> INSERT INTO DemoTable(CustomerName, CustomerTotalBill, PurchasingDate) VALUES('Chris', 1000, '2019-01-31');
mysql> INSERT INTO DemoTable(CustomerName, CustomerTotalBill, PurchasingDate) VALUES('Robert', 4500, '2018-01-01');
mysql> INSERT INTO DemoTable(CustomerName, CustomerTotalBill, PurchasingDate) VALUES('Sam', 5500, '2017-02-12');
mysql> INSERT INTO DemoTable(CustomerName, CustomerTotalBill, PurchasingDate) VALUES('Carol', 500, '2016-01-12');
टेबल से सभी रिकॉर्ड प्रदर्शित करें:
mysql> SELECT * FROM DemoTable;
आउटपुट:
+------------+--------------+-------------------+----------------+ | CustomerId | CustomerName | CustomerTotalBill | PurchasingDate | +------------+--------------+-------------------+----------------+ | 1 | John | 2000 | 2019-01-21 | | 2 | Chris | 1000 | 2019-01-31 | | 3 | Robert | 4500 | 2018-01-01 | | 4 | Sam | 5500 | 2017-02-12 | | 5 | Carol | 500 | 2016-01-12 | +------------+--------------+-------------------+----------------+
MySQL में विशिष्ट महीने और वर्ष के रिकॉर्ड प्रदर्शित करने के लिए क्वेरी:
mysql> SELECT * FROM DemoTable WHERE YEAR(DATE(PurchasingDate))=2019 AND MONTH(DATE(PurchasingDate)) = 01;
आउटपुट:
+------------+--------------+-------------------+----------------+ | CustomerId | CustomerName | CustomerTotalBill | PurchasingDate | +------------+--------------+-------------------+----------------+ | 1 | John | 2000 | 2019-01-21 | | 2 | Chris | 1000 | 2019-01-31 | +------------+--------------+-------------------+----------------+
