Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: GROUP BY

Re: GROUP BY

From: inger ruud <iru_at_provida.no>
Date: Tue, 22 May 2001 06:23:07 GMT
Message-ID: <fBnO6.634$_ub.179610112@news.telia.no>

It works! Thank you!

"TurkBear" <noone_at_nowhere.com> wrote in message news:kn7igtc1ob2knctc5lq5bahn2gv0jh7c27_at_4ax.com...
>
> Assume the field is named long_field then
> do a
> select substr(long_field,1,6) mygrp,count(something)
> from table
> group by substr(long_field,1,6);
>
> ( If field is a number, then do a substr(to_char(long_field),1,6)
 instead..)
>
>
>
> "inger ruud" <iru_at_provida.no> wrote:
>
> >Hi!
> >
> >I would like to group my query by part of a field.
> >
> >Ex.
> >
> >25000000497670000000000
> >27600000450947000000000
> >57800000491818000000002
> >57800000492500000000000
> >
> >I want to group by the 6 first characters.
> >
> >
> >
> >HELP!
> >
>
Received on Tue May 22 2001 - 01:23:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US