Re: group by

Which 'group' function are you using to group the data? ie: max, min, sum, count, etc...

example: Select id, name, max(salary), address from employees

              Group by id, name, address;

hanton32_at_hotmail.com wrote:

> Oracle 7 on Win95
>
> I am trying to group by a column with values such as :
>
> a
> ab
> abc
> abcd
>
> I would like to treat values 'a' and 'ab' as the same value for grouping
> purposes and also treat 'abc' and 'abcd' as one value for grouping purposes.
>
> is this possible without using pl/sql ?
>
> thanks
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Tue May 01 2001 - 11:51:12 CDT