Hello-
We are attempting to use OJB in an environment in
which a query can return a very large number of
results. We would like to be able to limit the
returned results to only the 10 at the top of the
ordered list.
In SQL, the statement would be along the lines of:
select * from
(select * from table where ... order by ...) where
rownum < 10;
Essentially, the outer select statement can be
hardcoded, but the inner is dependent on the current
query.
Is it possible to do this with OJB?
Thanks,
Josh
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
