Last Day of Month Orders
Medium
Date & String Functions
Return the orders placed on the last calendar day of their month. Return id and order_date, ordered by id.
Table schema
Orders(id INT PRIMARY KEY, order_date DATE)Sample data
id | order_date
1 | 2026-01-31
2 | 2026-02-27
3 | 2026-02-28
4 | 2026-03-15
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.