MySQL Function Reference

LEAD

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

MySQL 8.1

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 8.1

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;