Removing duplicates (or clearing-out database?)

[Brian Goodness]

Hi Joe,

Somehow, I think I might have created duplicate rows for games in the 2021 NBA data:

https://s3.sportsdatabase.com/NBA/query.html?sdql=Brian.date%2C+Brian.team%2C+points%2C+site%2C+o%3Asite%2C+o%3Ateam%2C+o%3Apoints%2C+data+datetimestamp+%40+date%3D20211020+and+team%3DHornets&submit=++S+D+Q+L+%21++

(1) Do you happen to have a good way to drop-out duplicates? (In this specific case, I think it'd be rows with a 'data datetimestamp' field of '2021-10-23 01:08:06')

(2) I haven't done much data-loading work thus far, and so I wouldn't mind just dropping my data and re-loading what I've done, from a clean slate. Is there a way for me to drop my data (without affecting any other users' data, of course), from which I can then load into a clean database?

Thanks,

Brian

[Joe Meyer]

Brian and API Friends,

To see just the games you have loaded, add the SDQL condition: 

Brian.date>0  

Please address any API questions to the entire group 

to increase the likelihood of receiving a reply.

Best regards,

Joe Meyer

Sport Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/ce90d3b4-a8de-4ee3-b4c6-492fd5e766dfn%40googlegroups.com.