![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 30 Jun 2011 @ 08:55:27 GMT
Subj: | | Re: Simple way Group by All Columns |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, June 30, 2011 03:10 -->
Hi,
There is no way to GROUP BY all columns without specifying them in Teradata. Instead, you can use DISTINCT in your select statement.
But, in T-SQL, there is a GROUP BY ALL. But this does not Group by all columns; this will use all the values of the column specified in group
by even if they were not qualified by the WHERE clause.
| |