[NBLUG/talk] OT - SQL query question

[Scott Doty]

On Fri, Dec 02, 2005 at 10:12:19AM -0800, Mark Street wrote:
> This is slightly off topic.  I have an old dBase database with 12000 records.  
> There are some records with the same address field.  I need to strip out the 
> DISTINCT address records into a separate database.
> 
> SELECT DISTINCT ADDR1 FROM MYDB gets me the unique addresses but I need the  
> other fields as well.
> 
> What would be the best way to do this?

Hi Mark,

I may be wrong, but I think you can just list the other fields that you
want...e.g.:  select distinct(ADDR1),field2,field3 from mydb ...

I haven't tried it, but that would be the first thing I'd try...

 -Scott