SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT payment_month, monthly_amount, LEAD(monthly_amount) OVER (ORDER BY payment_month) AS next_monthly_amount FROM ( SELECT DATE_FORMAT(payment_date, "%Y-%M") AS payment_month, SUM(amount) AS monthly_amount FROM payment WHERE YEAR(payment_date) = 2005 GROUP BY DATE_FORMAT(payment_date, "%Y-%M") ) AS subquery

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear