Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I remove duplicates values in my database?
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;
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;
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,
Intermodal2:
LOAD distinct
Key_Master,
VOYAGE_DESC_2,
VVL_D2,
BOOK_ID,
BL_Number_BDS,
resident Intermodal;
drop table Intermodal;