var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select top
i want to select the top 3 records, and i'm doing it like so...
select * from (select col1 from table1 order by col2) where rownum < 4
this works in oracle 8, but in oracle 7, it says missing right parenthes
does anyone know the problem?
my guess is oracle 7 doesn't allow order by in the sub query. If that is the case, is there an alternate solution to select top?
Re: select top
In Oracle 7 I think you would have to use a cursor.