Sng Ying#100DaysofSQL | DAY 20: How to populate of all field of duplicated customer_idWhen? Identify primary / composite keys OR check tables for unintended duplicatesJul 7, 2022Jul 7, 2022
Sng Ying#100DaysofSQL | DAY 19: How to check number of times a row is repeated?I should really be more diligent in posting more often, one of my friends joked about how my #100daysofSQL will take 365 days (instead of…Jul 7, 2022Jul 7, 2022
Sng Ying#100DaysofSQL | DAY 18: Assigning trx sequence for each unique customerUpon trying to calculate the replenishment rate of one product franchise group, here I learn how to assign transaction sequence for each…Jul 4, 2022Jul 4, 2022
Sng Ying#100DaysofSQL | DAY 17: Alternatives to DISTINCT!After using SQL for a while at work + reading medium articles, I realise that DISTINCT syntax does not always remove all duplicates as…Jun 14, 20221Jun 14, 20221
Sng Ying#100DaysofSQL | DAY 17: Window Functions are not scary!Read some interesting articles, namely this, this and this over the weekend, thus I would like to document some interesting findings :)Jun 2, 2022Jun 2, 2022
Sng Ying#100DaysofSQL | DAY 15: Coalesce function in SQLRead some interesting articles, namely this, this and this. over the weekend, thus I would like to document some interesting findings :)Jun 2, 2022Jun 2, 2022
Sng Ying#100DaysofSQL | DAY 14: Identify deplicated rows in tableRead some interesting articles, namely this, this and this. over the weekend, thus I would like to document some interesting findings :)Jun 2, 2022Jun 2, 2022
Sng Ying#100DaysofSQL | DAY 13: SQL OperatorsMy bad, I totally forgot to update here, but I am remember from now on!May 26, 2022May 26, 2022
Sng Ying#100DaysofSQL | DAY 12:Today I came across this article detailing the most commonly used syntax used for data cleansing — I share the ones I’m not so familiar…May 6, 2022May 6, 2022
Sng Ying#100DaysofSQL | DAY 11: Best SQL PracticesToday I came across this informative article: SQL Best Practices and decided to document the ones which I found interesting!May 3, 2022May 3, 2022