SQL question

From: Ken Halsted <kenman_at_mail.snider.net>
Date: Thu, 20 May 1999 17:25:48 -0500
Message-ID: <927239162.115.33_at_news.remarQ.com>

[Quoted] [Quoted] I am wondering if there is a way to ensure that only 1 row of information get's returned in a Query?

For example if a table (test) exists like:

A   VARCHAR2(1)
B   VARCHAR2(1)
C   VARCHAR2(1)
D   VARCHAR2(1)

E VARCHAR2(1) A, B, C, D make up the key.

Select *
From test t

where t.a = 'A'
and t.b = 'B'
and t.c = '1'

I only want one row to be returned even if there are more than one type of D [Quoted] [Quoted] information. I only want to see the unique rows of C for every A and B.

How can I do this easily?

Thanks for any help at all.

Ken Halsted.

--
_________________
Kenneth W. Halsted
Mountaire Corporation
ph: (501) 399-8812
url: http://www.mountaire.com
email: kenman_at_mail.snider.net

Received on Fri May 21 1999 - 00:25:48 CEST