How does works "group by" correct
SoftIl
softil at onlinehome.de
Thu Aug 12 23:34:15 CDT 2004
Hi all,
I've got some problems with "group by":
1)
If I try this:
select * from myTable group by date
the "group by" statement hasn't an effect.
If I write this
select *,count(any column) from myTable group by date
it works correct.
Why is it so? In no documentation I could find this, that I have to use
"count()" if I'd like to use "group by".
2)
How can I use "group by" for more than one column?
This statement works not correct. I get all records return:
select *,count(any column) from myTable group by date,ohrnummer
Thanks for your help.
Carsten
More information about the Valentina
mailing list