db2 select & group by

[monicaj]

Hi,

Can anyone suggest - what are the alternative means I achieve following functionality -

select x , y from table1 group by x

since rules say group by clause needs all listed fields in select clause. Forgive me for if the question is to naive. Thanks

[neeluj]

Hi Monica,

Suppose your table looks like
create table test(t1 number, t2 number, t3 number)

Use temporary table tb for selecting columns that are in group by as

select ta.t1, ta.t2, tt from test ta, (select t1, sum(t3) as tt from
test group by t1) tb
where ta.t1 = tb.t1

Neelu


QUOTE=monicaj]Hi,

Can anyone suggest - what are the alternative means I achieve following functionality -

select x , y from table1 group by x

since rules say group by clause needs all listed fields in select clause. Forgive me for if the question is to naive. Thanks[/quote]