select dummy,count(1) from dual group by dummy; O/p:
Error: Not a GROUP BY Clause
X,0
X,1
Two rows of value (X,0) & (X,1)
No rows returned