Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Can I do this using SQL?

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@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 - 04:22:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US