Wish-List

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

>  
> > 6)     Introduce TOP() function
> 
> Describe it please
>  

> 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]
> 

Hi Ruslan,

In SQL Server, TOP gives the first n records.

SELECT TOP 100 * FROM MyTable

Gives you the first 100 records.

I believe Valentina uses LIMIT, if I remember correctly.

-John