SQL Window Functions

Re:SQL Window Functions by cam8001 on Wednesday September 04, 2019 @01:01AM (#20874125)

The author explicitly states that she is using these in SQL Server, but I did a bit of digging and they are supported in ANSI SQL2003/2008, which is implemented by all the major vendors (MySQL, PostegreSQL, Oracle, DB2, SQL Server).

Wikipedia has some data on support: https://en.wikipedia.org/wiki/Select_(SQL)#Window_function_s...

[ Parent | on HN ]

Re:SQL Window Functions by michaelper22 on Wednesday September 04, 2019 @03:13PM (#20880445)

MySQL only as of 8.0, which also added CTEs, more JSON features, and index features relevant to indexing JSON.

[ Parent | on HN ]