Re: sql question - distinct

On 27 Nov 2006, soalvajavab1_at_yahoo.com wrote:
> How can I apply DISTINCT only to the first column in this query:
>
> SELECT DISTINCT UNIT_ID, BFP_NUMBER, METER_NUMBER
> FROM table_1
>
> It applies it to all 3 fields now. Pls advise.

If you table looks like this:

UNIT_ID BFP_NUMBER METER_NUMBER

1        10          100
1        11          101
2        12          102

What should the output be?

-- 
Galen Boyer