Re: GROUP BY....but not on all columns

<pankaj_wolfhunter_at_yahoo.co.in> a écrit dans le message de news: 1182022067.132225.271110_at_n15g2000prd.googlegroups.com...
| 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
|

Instead of posting a wrong query
post your needs in functional terms.
What do you want?

Regards
Michel Cadot Received on Sat Jun 16 2007 - 15:41:48 CDT