web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Archive for category "SQL Standard"
formats

Why the SQL Standard does not need another way to do GROUP BY

In a recent article, Lukas Eder proposed enhancements to the SQL Standard’s GROUP BY syntax to include support for implicit grouping attributes, such as that provided by the Cypher query language. I applaud Lukas’ efforts to define useful changes to the SQL language, but I am going to try to show in this article that

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

The first deadly sin

In this semester I’m teaching two SQL fundamentals courses, one with MySQL and one with Microsoft SQL Server. We are quickly reaching the point where the notions of query equivalence and support for domains will be necessary – and that reminded me of this blog post that I wrote last spring while I was still

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments