Community

Public Snippets 1

Code shared by the SaveSnippets community — browse, copy, and get inspired.

#first-value Clear
Tags #php #kotlin #bash #go #sql #rust #typescript #html #java #python #files #utils #strings #http #concurrency #async #json #arrays #security #types #crypto #database #dates #format
SQL FIRST_VALUE / LAST_VALUE
Return the first or last value within a window. Useful for "compare each row to the partition's first/last value" — for example, "how much have we grown since the user's first order?"
#sql #window #first-value #last-value
admin @admin ADMIN 1h ago 0
View