Re: DISTINCT

On Mon, 20 Apr 1998 10:51:31 -0400, Min Wang <mwang_at_colorbank.com> wrote:

>How to get distinct X, Z when query Z=3? Say, we just want show (1, 3)
>instead of (1,3), (1,3).

Like this:         

        select distinct X,Z from table where Z=3; Received on Tue Apr 21 1998 - 22:01:33 CDT