4 ms·
Im very ignorant of partition by, but it doesn’t look like it works? http://sqlfiddle.com/#!15/696cb/1 http://sqlfiddle.com/#!15/696cb/1
by williamdclt 3y ago
Im very ignorant of partition by, but it doesn’t look like it works? http://sqlfiddle.com/#!15/696cb/1 http://sqlfiddle.com/#!15/696cb/1
- withinboredom 3y agoIt doesn't. http://sqlfiddle.com/#!15/7eb3a/7 http://sqlfiddle.com/#!15/7eb3a/7 is a proper implementation using windowing functions to get the first something.