Deduplicate access records
$10-15 USD
Płatność przy odbiorze
I need a query performed on this db which deletes only TOTAL DUPLICATES and NOT words which are duplicated. Please look at the examples below to understand the difference between records which are total duplicates (every element except the number is identical and therefore redundant) and partial duplicates on the WORD (these records are extremely useful).
I would like a very very very very simple note on how to do this query
eg
1) Create Query
2) Select columns except ID number
3) In design view Select "Group by"
etc etc with no explanations how it works, just a recipe to follow.
WORD DUPLICATES:
43373 come out intransitive verb 2 [socially] sortir would you like to come out with me tonighté est-ce que tu veux sortir avec moi ce soiré if he'd only come out of himself or out of his shell (figurative) si seulement il sortait de sa coquille
32519 come out intransitive verb 1 2 photography the pictures came out well/badly les photos étaient trés bonnes/n'ont rien donné the house didn't come out well la maison n'est pas trés bien sur les photos
REAL TOTAL DUPLICATES:
111866 look up intransitive verb 1 [raise one's eyes] lever les yeux
111929 look up intransitive verb 1 [raise one's eyes] lever les yeux
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
xp
Numer ID Projektu: #3554656