c.d.t. is the wrong forum to ask this question, but I reckon it's a
good place to find folk who've Got a Clue (tm).  :-)
Which SQL dialects have you encountered that support aggregates in the
GROUP BY clause?  

i don't know much about SQL - just basics: tables, indexes, simple
selects and
i'm designing simple database storing key/value data (in fact its
read

I am working with a database that tracks sector scores for economic
data.  There are five sectors that are scored for geography entities.  A
scoring record is entered for each geo entity for every month.  I need
to find the highest Total Score (=Sect1Score + Sect2Score ... +

I am working on a data model that uses a nested set in MySQL. I'm semi-
aware of the relational and other shortcomings of MySQL; please
forgive me if discussion of the platform is verboten here. I have a
problem that I believe is a general RDBMS problem; if it is instead a

Criticisms, please (preferably ones based on some formal logic or other).
It is inescapable that every relation is a join (eg., Heath's theorem).  
So every relvar points to a join.  If we can't 'delete' through a join,
we can't delete from any relvar (my father, who thought a disk ...

I get the impression that a lot of the time, a query (or a large
portion of a query) can be thought of as a navigation from attribute
to attribute using a sequence of joins.  This made me think there may
be some merit in thinking of attribute names as global in nature and