sql question - distinct

Giganews Newsgroups
Subject: sql question - distinct
Posted by:  soalvajava…@yahoo.com
Date: 27 Nov 2006

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.

Replies