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: most sold pc's query?

Re: most sold pc's query?

From: drukqs <invalid.drukqs_at_NOpandoraSPAM.belgie>
Date: Sat, 10 May 2003 13:37:24 GMT
Message-ID: <Xns93779F97DCF74invaliddrukqspandora@195.130.132.68>


Daniel Morgan wrote in news:3EBBF2AA.519BDEBF_at_exxesolutions.com:

> Lets say I think you are a student and I have given you hints
> sufficient for you to do your homework.
>
> And unless you have an alternative explanation for asking such a basic
> question and not being able to ask a more senior co-worker I encourage
> others to not do your homework for you.

Yes I am a student. I am not asking here to do all my homework for me. I'm learning this. I just ask small things, nothing wrong with that. Who wants to help, ok, who doesn', also ok.
This is how I become the number of most sold pc's in march:

select max(count(pcnr))
into :testblock.number_of_pcs
from computerssold
where date between '01-mar-03' and '31-mar-03' group by pcnr;

But I want to be able to select the month. So when I push the button that has the trigger I like to see the most sold pc's of the month o which field I selected. So I click in order number 1 which has 1 pc sold in april. Next I click the button and then I have to see most pc's sold in april. Get it? I don't need a complete sollution here, any hints are good. Thx Received on Sat May 10 2003 - 08:37:24 CDT

Original text of this message

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