LIMIT V4MD1

[Ruslan Zasukhin]

On 5/4/05 3:37 PM, "Sims, John" <ayu8 at cdc.gov> wrote:

> Hi Ruslan and Florian.
> 
> Ruslan, is the "TOP" keyword part of SQL 92, and if it is, is it
> implemented in v2?

It is not in SQL92, but it seems added into SQL99

Yes in 2.0 it works...
Although still many improvements can be made yet here
 
> If so, this should do the trick for Florian.
> 
> SELECT TOP 1 * FROM TABLE

But he use 1.x 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]