SQL Function Reference

LEAD

Оконная функция. Обращается к данным из следующих строк окна.

MySQL

LEAD(column [, offset ] [, default])

column

Column whose value is to be returned

offset

Number of lines to offset (default 1)

default

The value to return if NULL is returned after the offset

Examples

MySQL

SELECT 
    member_name, 
    status, 
    LEAD(member_name) OVER(ORDER BY status) AS 'lead_1',
    LEAD(member_name, 2, 'empty') OVER(ORDER BY status) AS 'lead_2' 
    FROM FamilyMembers;