SQL Function Reference

FIRST_VALUE
Window function. Returns the first value in the window.
MySQL
FIRST_VALUE(column)
column
Column whose value is to be returned
Examples
MySQL
SELECT member_name,
	STATUS,
	FIRST_VALUE(member_name) OVER(
		PARTITION BY STATUS
		ORDER BY STATUS
	) AS 'first_value'
FROM FamilyMembers;