Re: query returns no results

From: Arne Beenck <Arne.Beenck_at_de.bosch.com>
Date: Thu, 4 Jul 2002 16:01:25 +0200
Message-ID: <ag1kji$mi6$1@ns2.fe.internet.bosch.com>

Hello Ryan,

try this one:

SELECT col1, col2, r2
FROM (SELECT col1, col2, rownum r2

              FROM table1 WHERE rownum < 20
              ORDER BY col1) r

WHERE r2 > 10

Arne Received on Thu Jul 04 2002 - 09:01:25 CDT