Re: How to get the same subset of records within a web session

From: David <dfairman16_at_hotmail.com>
Date: 15 Apr 2002 06:41:38 -0700
Message-ID: <b4cefdce.0204150541.7a2f4bee_at_posting.google.com>

See Barry Bulsara's post yesterday followed up by Bricklen Anderson. The analytic function solution is better than how I have previously achieved this result (which is posted below to show you not how to do it, in this case retrieving the second window of 2 hits). David

CREATE TABLE fred(string1 VARCHAR2(10));

INSERT INTO fred VALUES ('test1');
INSERT INTO fred VALUES ('test4');
INSERT INTO fred VALUES ('test7');
INSERT INTO fred VALUES ('test8');
INSERT INTO fred VALUES ('test32');
INSERT INTO fred VALUES ('testgg');
INSERT INTO fred VALUES ('test78');

SELECT string1,ROWNUM
FROM fred
WHERE ROWNUM < 5
GROUP BY ROWNUM,string1
HAVING ROWNUM > 2; brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0204150049.4e7a6e3b_at_posting.google.com>...
> How to get the same subset of records, e.g. records 50-100 in the same
> web session for a web database?
Received on Mon Apr 15 2002 - 15:41:38 CEST