As the title may imply I want to keep the maximum value in field2 for several identical IDs in field1, the others are deleted for example this table:
Field1 Field214772 114772 414766 314766 114766 114766 114766 114765 114765 314765 1becomes:Field1 Field214772 414766 314765 3by deleting all the duplicate ID (field1) with lower value in field2. for your information my final objective is to join the table with another using field1, I only want rows with highest field2 value to be joined.
أكثر...
Field1 Field214772 114772 414766 314766 114766 114766 114766 114765 114765 314765 1becomes:Field1 Field214772 414766 314765 3by deleting all the duplicate ID (field1) with lower value in field2. for your information my final objective is to join the table with another using field1, I only want rows with highest field2 value to be joined.
أكثر...