Re: SQL query: how can I hide a column in output?

On 17 Aug 2006 11:52:28 -0700, "Ray Saltrelli" <reymundo514_at_gmail.com> wrote:

>Sometimes you may need to have a column in the SELECT clause in order
>to group by that column, for example, but you may not want to actually
>display it. Try this:
>
>SELECT a, b, FROM (SELECT a, b, c FROM Table1 GROUP BY c );
>

You don't need to specify the column you want to group by in the select list, so

SELECT a, b FROM Table1 GROUP BY c

Is legal syntax.

Jaap. Received on Mon Aug 28 2006 - 13:28:37 CDT