"Bullschmidt" wrote:
And here's a concept behind a different way of paging:
What's after TOP? by graz - 8/31/2000
http://www.sqlteam.com/item.asp?ItemID=566
That seems even more elegant than the set subtraction technique allowed in
Oracle:
SELECT {fields} FROM {table} WHERE {primary key} IN
( SELECT {primary key} FROM {table or index table}
WHERE {condition} AND rownum < {upper bound}
MINUS
SELECT {primary key} FROM {table or index table}
WHERE {condition} AND rownum < {lower bound}
)
I wonder which is more efficient.
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.