为什么我需要在SQL“GROUP BY”子句中明确指定所有列 - 为什么不“GROUP BY *”？

This has always bothered me - why does the GROUP BY clause in a SQL statement require that I include all non-aggregate columns? These columns should be included by default - a kind of "GROUP BY *" - since I can't even run the query unless they're all included. Every column has to either be an aggregate or be specified in the "GROUP BY", but it seems like anything not aggregated should be automatically grouped.This has always bothered me - why does the GROU