GROUP BY....but not on all columns

Greetings,

          I need to apply a group by in my query but not necessarily on all columns in select list.

For eg:

select col1, col2, col3, col4, col5
from table_name
group by col1, col2, col3, col4

Now the requirement is to include all 5 columns but group by only first 4

How can I achieve this? Any help would be appreciated.

TIA Received on Sat Jun 16 2007 - 14:27:47 CDT