Re: group by

From: <hanton32_at_hotmail.com>
Date: 1 May 2001 18:36:26 GMT
Message-ID: <9cmvna$kmc$1@news.netmar.com>

count

In article <3AEEE980.48938DA9_at_eis.ca>, Munzil Qureshi <munzil_qureshi_at_eis.ca> writes:
>
>
>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
>

• 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 - 13:36:26 CDT