[GENERAL] Re: SQL command ?

[Kevin C. Dorff]

Select distinct year from yearstable;

--Kevin

On Thu, 9 Mar 2000 18:58:44 +0200, "selifx" <[EMAIL PROTECTED]>
wrote:

>What SQL command can return (one field) recordset without dublicates from
>table (one field) with dublicates.
>example:
>
>Table :
>
>1999
>2000
>1999
>1998
>2000
>
>necessary recordset :
>
>1999
>2000
>1998
>
>Thanks.
>