DISTINCT

From: Min Wang <mwang_at_colorbank.com>
Date: Mon, 20 Apr 1998 10:51:31 -0400
Message-ID: <353B60F3.C47E052C@colorbank.com>

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.

--

Min Wang
E-mail: mwang_at_colorbank.com
http://www.colorbank.com/
http://www.shopfast.com/ Received on Mon Apr 20 1998 - 09:51:31 CDT