No duplicates

[Ruslan Zasukhin]

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