Hi Milan!

At 12:24 24.07.2003 +0000, you wrote:

>Hi,
>i have question, is possible this query?
>
>SELECT P1,P2,P3 FROM TAB1 GROUP BY P1

No, currently you need to group by all columns that is not aggregate
columns, i.e.

SELECT P1,P2,P3 FROM TAB1 GROUP BY P1, P2, P3

or (for example)

SELECT P1, MAX(P2) , SUM(P3) FROM TAB1 GROUP BY P1

Did you think group by served another purpose?

Set