Remove duplicates

[#1]

How can I remove duplicates values in my database?

[johnw · Accepted solution]

That probably depends on what you mean by duplicate values and by removing them.  One simple approach for some cases would be this:

SELECT DISTINCT FIELD1, FIELD2, FIELD3, etc.
FROM your database;

[#3]

Hello John, in this example below how can i use this comand select distinct for field Key_Master?

I already tried to do where exists (Key_Master) but with no success.

Intermodal2:

LOAD

  Key_Master,

  VOYAGE_DESC_2,

  VVL_D2,

  BOOK_ID,

  BL_Number_BDS,

resident Intermodal;

drop table Intermodal;

Rgds,

[klausskalts]

Intermodal2:

LOAD distinct

  Key_Master,

  VOYAGE_DESC_2,

  VVL_D2,

  BOOK_ID,

  BL_Number_BDS,

resident Intermodal;

drop table Intermodal;