var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: To select a limited number of records
May be it sounds very trivial, but how can i select a limited number of records in Oracle, like in Microsoft SQL Server
select top 1 ... ?
Thanks in advance for your help!
Use ROWNUM, e.g.:
select ename, sal from
( select ename, sal from emp order by sal desc)
where rownum = 1;
Note that the following would not work:
select ename, sal from emp
where rownum = 1
order by sal desc;
... because the ROWNUM is applied before the ORDER BY. You will get 1 record, but it will not necessarily have the top salary value.