Re: SQL question

Ken Halsted a écrit dans le message <927239162.115.33_at_news.remarQ.com>...
>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
>information. I only want to see the unique rows of C for every A and B.
>

I would say '... AND ROWNUM=1', or maybe with a 'GROUP BY' Received on Fri May 21 1999 - 09:24:48 CEST