News for hackers. Stuff that matters.

cam8001

cam8001 on Hacker News

Re:SQL Window Functions 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...

Re:The more you learn, the faster you can learn on Monday September 02, 2019 @12:20AM (#20856749)
Subject Matter Expert, I think.