3 ms·
That example code seems overly complicated and redundant. Should the code be simpler like this: SELECT id , max(a) ma , count(*) Cnt FROM
by wesd 8y ago
That example code seems overly complicated and redundant. Should the code be simpler like this:
SELECT id
, max(a) ma
, count(*) Cnt
FROM ...
GROUP BY id
- MarkusWinand 8y agoThe purpose of the example is to demonstrate functional dependencies based on grouped tables.