The query without [font="Courier New"]group by[/font] looks strange.

In case the table is populated, it must return millions of rows.