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: create view performance problem

Re: create view performance problem

From: <dnotari_at_yahoo.com>
Date: Thu, 06 May 1999 15:19:52 GMT
Message-ID: <3733b124.24571491@newshost.us.oracle.com>


Vagelis,
 try this

select symbol, st_date, value
from test a
where (a.value) = (select max(b.value)
from test b where a.symbol = b.symbol group by symbol) /

Dante

On Sun, 2 May 1999 16:40:46 +0300, "vagelis Hristidis" <exrist_at_cc.ece.ntua.gr> wrote:

>I have a table with columns :symbol, st_date,value
>and I would like to create a view with columns:
>symbol,st_date_for_max_value,max_value
>where there is one row for each stock symbol.
>How can I do it so that it performs well?
>The problem is that sql won't let me use st_date in select clause when i
>don't also put it in group by clause.If I use a pl/sql function it's slow.
>Thanks in advance.
>
>vagelis
>
Received on Thu May 06 1999 - 10:19:52 CDT

Original text of this message

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