News for hackers. Stuff that matters.

A comment on Medium-hard SQL interview questions. Parent comment

Re:Medium-hard SQL interview questions by mycall on Saturday May 02, 2020 @07:27PM (#23055700)
The problem with SQL windowing functions (OVER ORDER BY, LAG/LEAD, RANK, etc) is that they are nondeterministic.
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by WoahNoun on Saturday May 02, 2020 @07:48PM (#23055784)
They are only indeterminate when the SQL engine is given an ambiguous ordering. If you specify the ordering without ambiguity, it's entirely deterministic.

Eg: indeterminate in -> indeterminate out

but determinate in -> determinate out.

[ Parent | on HN ]