🚀 go-pugleaf

The GROUP BY clause in an SQL statement is only REQUIRED
if aggregation (SUM, MIN, MAX, AVG, etc.) is being performed
on one or more fields in the SELECT statement.

I use SQL every day in my job (my job title is Query Master for an
Informix database), and there are many occasoins when I just need
raw data.  In those cases, I use a simple SELECT statement.

Perhaps I'm missing something in your post.  If there is something
specific you are trying to get SQL to do, perhaps we can be of
more assistance if we have more information.

Hope this helps,

Michael

socopa Informatique cherre wrote in message <7perqg$lk2$1@wanadoo.fr>...
>Hello all,
>   I looked for a sql newsgroup but i didn't find so...
>   Here is my question :
>
>            Is it possible (in any way) to use only SELECT commands instead
>of the GROUP BY command.
>            To my mind, it's not possible but i'd like to be confirmed.
>
>                    Thanx in advance.  Fabrice
>
>
>