select job from user_jobs where rownum=? Please help

From: anurag <aminochaNOamSPAM_at_unibiz.com.invalid>
Date: 2000/08/04
Message-ID: <033531d8.ad5f1e39@usw-ex0104-033.remarq.com>#1/1

Hi,

When I give the following query it returns me 2 rows. But when I include rownum in my where clause it does not return anything. Please help

SQL> select rownum,job from user_jobs;

   ROWNUM JOB
--------- ---------

        1        60
        2        61

SQL> select rownum,job from user_jobs where rownum=2;

no rows selected

Thanks
Anurag

---

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Aug 04 2000 - 00:00:00 CDT