Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: most sold pc's query?
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