No duplicates

[Roger Amar]

Hi Ruslan,

It's great... and fast like a flash !
Exactly 107 ms to obtain a list of 356 lines with no duplicates from 53780 records !
I am amazed !
Thank you again,

Roger;
 

-----Message d'origine-----
De : valentina-bounces at lists.macserve.net [mailto:valentina-bounces at lists.macserve.net] De la part de Ruslan Zasukhin
Envoyé : lundi 31 janvier 2005 11:21
À : valentina at lists.macserve.net
Objet : Re: No duplicates

On 1/31/05 12:01 PM, "Roger Amar" <Roger at logram.com> wrote:

> Hello,
> 
> In a database of music titles I want to obtain list of interpreters 
> without duplicates.
> Is there any way to get result from a cursor without duplicates ?

Hi Roger,

You should use DISTINCT key word


    SELECT DISTINCT title, ... FROM T


--
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina