Re:Window Functions in SQL (2013)
by Jweb_Guru on Thursday October 06, 2016 @01:47AM
(#12650478)
Eh, there's been work done on this, e.g. order dependencies. Not sure how much of it has made it into commercial SQL engines, though.
[ Parent
| on HN ]
link?
Here's one: https://arxiv.org/pdf/1208.0084v1.pdf
(Note the involvement of IBM. Dunno whether this has made it into DB2, but a lot of really interesting research has; also keep in mind that whatever IBM wants to put in DB2 has a high probability of making it into the SQL standard).