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: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 25 Jul 2007 18:11:32 +0200
Message-ID: <46a77633$0$28031$426a74cc@news.free.fr>

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1185368364.646707.30240_at_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?
|

Just work a little bit and search for what I said.

Regards
Michel Cadot Received on Wed Jul 25 2007 - 11:11:32 CDT

Original text of this message

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