Re: Tricky SQL Problem: Top "n" of queried records

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/03/21
Message-ID: <6f0rfo$5v3$1@pebble.ml.org>#1/1

In article <3512F42A.B4591493_at_kenan.com>, Brenda Muller <bmuller_at_kenan.com> wrote:
>In Sybase (and Sybase alone), you can "set rowcount 3" at the beginning of your
>transaction, which will restrict the server to returning only 3 rows. There is
>nothing analogous to this in Oracle.

In sybase, you can wait forever because one of those rows is on the same page as a completely unrelated row that someone has locked up. There is nothing analogous to this in Oracle.

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!

Received on Sat Mar 21 1998 - 00:00:00 CST