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

Home -> Community -> Usenet -> c.d.o.misc -> Re: extracting a sample of each condition

Re: extracting a sample of each condition

From: jobs <jobs_at_webdos.com>
Date: Wed, 25 Jul 2007 05:59:24 -0700
Message-ID: <1185368364.646707.30240@b79g2000hse.googlegroups.com>


On Jul 25, 3:18 am, Akhilesh <toakkiya..._at_gmail.com> wrote:
> try out this query:
>
> select plan, type1, type2, type3 from table
> where <<conditions>>
> group by plan, type1, type2, type3
>
> might help you out

How would that give me the the first Name and Amount for each group? Received on Wed Jul 25 2007 - 07:59:24 CDT

Original text of this message

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