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:22:05 GMT
Message-ID: <hAnO6.633$_ub.180026880@news.telia.no>

thank you :)

<xmark.powell_at_eds.com.x> wrote in message news:9eb5cg$f4j$1_at_news.netmar.com...
> In article <9i8O6.591$_ub.180023808_at_news.telia.no>, inger ruud
> <iru_at_provida.no> writes:
> >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!
> >
> >
> Try "group by substr(colname,1,6) "
>
> -- MArk D Powell --
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
 eb -----
> 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 22 2001 - 01:22:05 CDT

Original text of this message

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