LIMIT V4MD1

[Sims, John]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of D.Croes
> Sent: Wednesday, May 04, 2005 8:30 AM
> To: 'Valentina Developers'
> Subject: RE: LIMIT V4MD1
> 
> 
> 
> Hai Ruslan
> 
> Could you give an example, or further explain on:
> 
> Then use its first N records.
> 
> I can't seem to get the picture:D
> 
> Thanks!
> 
> 
> On 5/4/05 11:40 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:
> 
> Hi Florian,
> 
> > Hi!
> >  
> > How can I do something like "SELECT * FROM TABLE LIMIT 1"?
> 
> Just build cursor,
> Then use its first N records.
> 
> Effect the  same
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 

Hi Ruslan and Florian.

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

If so, this should do the trick for Florian.

SELECT TOP 1 * FROM TABLE

Take care,

-John