GROUP BY empty grouping set

SELECT COUNT(*)
FROM BOOK
GROUP BY ()
 

create.selectCount()
      .from(BOOK)
      .groupBy()
      .fetch();

selectCount().from(BOOK).groupBy()

SELECT count(*)
FROM BOOK, (select count(*) dual from MSysResources) as empty_grouping_dummy_table
GROUP BY empty_grouping_dummy_table.dual

SELECT count(*)
FROM BOOK, (select 1 as dual) as empty_grouping_dummy_table
GROUP BY empty_grouping_dummy_table.dual

SELECT count(*)
FROM BOOK
GROUP BY (SELECT 1
FROM DUAL)

SELECT count(*)
FROM BOOK
GROUP BY ()

SELECT count(*)
FROM BOOK
GROUP BY (SELECT 1)

SELECT count(*)
FROM BOOK
GROUP BY GROUPING SETS (())

SELECT count(*)
FROM BOOK
GROUP BY 0

SELECT count(*)
FROM BOOK
GROUP BY (SELECT 1
FROM RDB$DATABASE)

SELECT count(*)
FROM BOOK, (select 1 as dual from systables where tabid = 1) as empty_grouping_dummy_table
GROUP BY empty_grouping_dummy_table.dual

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website