Keep the latest payment per order

An order can have several payments rows (e.g. a failed attempt then a capture). Keep only each order's latest payment by paid_ts; if two payments share the latest paid_ts, keep the one with the higher payment_id (recorded later). Sort by order_id.

Returnorder_idstatusamount_usd

Columns

payments5 columns

columntype

payment_idVARCHAR

order_idVARCHAR

paid_tsTIMESTAMP WITH TIME ZONE

amount_usdBIGINT

statusVARCHAR

The table

12 rows · 5 columns

paymentsfirst 5 of 12 rows

payment_idorder_idpaid_tsamount_usdstatus

pay_001o_0012026-05-10 10:05:00100captured

pay_002o_0022026-05-15 11:05:00200captured

pay_003o_0032026-05-20 09:35:0050captured

pay_004o_0042026-05-12 14:25:00150captured

pay_005o_0052026-05-25 08:18:0075failed

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows