DZone
The SQL standard knows a lesser known feature called GROUPING SETS. One particular side-effect of that feature is that we can group by "nothing" in SQL. E.g. when querying the Sakila database:
SELECT count(*)
FROM film
GROUP BY ()This will yield:
Source: DZone