OraFAQ Forum: SQL & PL/SQL » how to limit row number

Home » SQL & PL/SQL » SQL & PL/SQL » how to limit row number

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to limit row number [message #160619]

Mon, 27 February 2006 12:59

emilu
Messages: 4
Registered: February 2006

Junior Member

normally, we run
select * from tableName where rownum=1; to limit the number

However since we have a very old version oracle rdb "Oracle ODBC Driver for Rdb Version 3.1.0.2"

It seems that this old version oracle rdb did not support rownum, are there other ways to limit row number please?

Thanks a lot,
Emi

Report message to a moderator

Re: how to limit row number [message #160739 is a reply to message #160619]

Tue, 28 February 2006 04:05

orausern
Messages: 826
Registered: December 2005

Senior Member

best is to upgrade your software...but one way around may be that,if rownum does not work, check if perhaps rowid is working and give query like:

 select * from a where rowid in (select min(rowid) from a);

It worked for me using sqlplus:

SQL> select * from a where rowid in (select min(rowid) from a);

         C C1
---------- ----------
         1 abc

SQL> desc a
 Name                                                              Null?    Type
 ----------------------------------------------------------------- -------- --------------------------------------------
 C                                                                          NUMBER
 C1                                                                         VARCHAR2(10)

SQL> select * from a
  2  /

         C C1
---------- ----------
         1 abc
         2 oracle
         3 sql

SQL> select * from a where rowid in (select min(rowid) from a);

         C C1
---------- ----------
         1 abc

Report message to a moderator

Previous Topic:	"OR" and "IN"
Next Topic:	SQL doubt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 02 11:24:11 CDT 2025