[williamdclt]

Im very ignorant of partition by, but it doesn’t look like it works? http://sqlfiddle.com/#!15/696cb/1

[withinboredom]

It doesn't. http://sqlfiddle.com/#!15/7eb3a/7 is a proper implementation using windowing functions to get the first something.