Re: Can I do this using SQL?
From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Wed, 15 Feb 2006 11:22:05 +0100
Message-ID: <dsuvdr$gra$1_at_online.de>
Date: Wed, 15 Feb 2006 11:22:05 +0100
Message-ID: <dsuvdr$gra$1_at_online.de>
dhruv wrote:
> Maybe I'm wrong, but doesn't SQL92 already have the LIMIT clause which
> can limit the number of results, or is that an Oracle/MySql extension?
You are wrong :-)
LIMIT or TOP is proprietary.
> I'm asking, because I tried LIMIT on both, and it seemed to work just
> fine.
LIMIT on Oracle? Could you show that query?
Dieter Received on Wed Feb 15 2006 - 11:22:05 CET