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;