Re: DISTINCT

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Mon, 20 Apr 1998 20:21:05 GMT
Message-ID: <353ba785.1209218@www.sigov.si>

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

>How to use distinct in query?
>
>Let's say there is table A
>
>X Y Z
>--------
>1 2 3
>1 2 4
>1 3 3
>
>How to get distinct X, Z when query Z=3? Say, we just want show (1, 3)
>instead of (1,3), (1,3).
>Thanks.

SELECT DISTINCT x, z FROM a WHERE z = 3;

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Apr 20 1998 - 15:21:05 CDT