GROUP BY clause in DB2 UDB 7.2
Posted on 2004-04-19
Environment details:AIX 5.1,DB2 UDB 7.2 with FIX pack 11
I have a table with 140 columns containing 3 lakh records.
I am writing a query which includes all 140 columns but i need to group by only on 2 columns .
Select col1,col2,col3,col4...col140 from class_cov_code_t
group by col1,col14
The above statement raises error. (All statements in select should be include in group by clause but i require only few columns from the select list). How can this be achived .
Thanks in adv