[TYPO3-dev] select distinct in TS
Christian Welzel
gawain at camlann.de
Mon Feb 20 23:22:58 CET 2006
Ries van Twisk wrote:
> Group by is also supported by postgresql.. I think also ms sql support
> group by.
Thats right, postgres does support "group by" but not the way
mysql does.
in mysql you can "group by" by only ONE column but select many.
like this:
SELECT * FROM table GROUP BY some_column;
and this query does not work in any db other than mysql.
And as i understood Helge, he suggested using such a query.
--
MfG, Christian Welzel
GPG-Key: http://www.camlann.de/key.asc
Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
More information about the TYPO3-dev
mailing list