Rownum in Oracle 8.0.x

From: Christian Hartmann <c.hartmann_at_tmp-office.de>
Date: Wed, 22 Aug 2001 15:32:23 GMT
Message-ID: <3b83d04c.9503625@news.ewetel.net>

Hi there,

this works propery in Oracle 8.1.x and higher:

select * from
(select eur_kurs
from waehrung
where c_waehrung='USD'
and i_firm_refid=:i_firm_refid
and d_tag<=:d_tag
order by d_tag desc)
where rownum=1

Unfortunately it doesn't work within an Oralce 8.0.x :-(

Is there a workaround?

Mfg,

Christian Hartmann
.tmp Informationssysteme GmbH & Co. KG
Oracle Certified Solution Partner
Roonstrasse 1, D-26122 Oldenburg
Germany
Tel.: +49-441-983983
Fax: +49-441-9839878
http://www.tmp-office.de Received on Wed Aug 22 2001 - 10:32:23 CDT