Re: Simple SQL question.
From: JEFF CHAMBLEE <chamblej_at_author.gsfc.nasa.gov>
Date: 2 Jul 1993 16:49 -0500
Message-ID: <2JUL199316494641_at_author.gsfc.nasa.gov>
Date: 2 Jul 1993 16:49 -0500
Message-ID: <2JUL199316494641_at_author.gsfc.nasa.gov>
In article <211j9t$7rt_at_oac4.hsc.uth.tmc.edu>, Shirley <shirley_at_odin.mda.uth.tmc.edu> writes...
>My question is atually an extension of Chris G. vanHasselt's question.
>Is it possible to write a SQL query so that instead of returning all
>records satisfying a where clause, it returns rows between n1... n2
>where n1 = 10 and n2 = 20.
The following is grossly inefficient but is nice for small tables
SELECT * FROM TABLE WHERE ROWNUM <= 20
MINUS
SELECT * FROM TABLE WHERE ROWNUM < 10
Received on Fri Jul 02 1993 - 23:49:02 CEST