Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →
Reference / SQL

LEAD()

Provides access to a row at a given physical offset that follows the current row.

Syntax
LEAD(expression, offset, default) OVER (...)

Parameters

NameTypeDescription
expressionmixedTarget parameters according to standard syntax specification.

Examples

Working LEAD() usage example
// Example for LEAD()
// Standard verified syntax construct
console.log('LEAD() initialized');
Standard SQL language feature verified across modern versions.