Cheat Sheet logoCheat Sheet Today
SQL Window Functions and CTEs/Use FIRST_VALUE and LAST_VALUE

Return boundary values within a window frame.

Back to sheetBrowse commands
Sign in to save
Section: Lag, Lead, and Value Navigation

Use FIRST_VALUE and LAST_VALUE

sql
sql
SELECT customer_id, order_id, amount,
       FIRST_VALUE(amount) OVER (PARTITION BY customer_id ORDER BY created_at) AS first_order_amount
FROM orders;
Explanation

Window frame details affect LAST_VALUE behavior in some dialects.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Lag, Lead, and Value Navigation
Use LAG
Read a value from the previous row in the same partition.
OpenIn sheetsqlsame section
Use LEAD
Read a value from the next row in the same partition.
OpenIn sheetsqlsame section
Assign row numbers
Number rows within an ordered partition.
OpenIn sheetsql1 tag match
Bucket rows with NTILE
Divide ordered rows into a fixed number of groups.
OpenIn sheetsql1 tag match
Rank rows
Assign ordered rankings with or without gaps.
OpenIn sheetsql1 tag match
Use PERCENT_RANK and CUME_DIST
Measure relative row position inside an ordered set.
OpenIn sheetsql1 tag match