Re: create view performance problem

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