#sqlwithidc ผลการค้นหา
Day 12 #SQLWithIDC In SQL, NULL is not a value it’s the silence between the notes. It’s the unknown, the missing, the unrecorded. IS NULL, IS NOT NULL, COALESCE() these are not just keywords, they’re the tools to give meaning to absence. @indiandataclub @dpdzero
Day 14 #SQLWithIDC INNER JOIN seeks alignment LEFT JOIN preserves perspective RIGHT JOIN changes it A NULL in a LEFT JOIN isn’t absence — it’s a story untold, a connection yet to be made Data reminds us: inclusion reveals as much as matching ever will @indiandataclub @dpdzero
Day 12 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: NULL Handling Learned how to work with missing data using IS NULL, IS NOT NULL, and COALESCE() to replace NULLs and ensure accurate filtering and calculations. #SQLWithIDC #LearnSQL #IDCChallenge
day -18/21 Days SQl challenge #SQLwithIDC Getting back to the Grind of SQL with @indiandataclub and @dpdzero
𝗗𝗮𝘆 12 #21DaysSQLChallenge 🚀 Handling NULLs & comparing categories ✅ IS NULL / IS NOT NULL ✅ COALESCE for fallback ✅ COUNT(*) vs COUNT(column) ✅ CTE + CASE for clean summaries ⚠️ Don’t treat NULL as a value Stepwise queries = clear & scalable SQL! 🙌 #SQLWithIDC
Day 18 #SQLWithIDC 🔶UNION removes duplicates, slower but unique results. 🔷UNION ALL keeps all rows, faster performance. 🔶Same columns + compatible types. Use ORDER BY last. Pro tip: Use UNION ALL when duplicates aren't an issue! @indiandataclub @dpdzero
Day 21 #SQLWithIDC CTEs transform tangled logic into elegant, reusable steps, turning complexity into insight. From simple stats to multi-step analysis, CTEs are a game-changer for query organization. @indiandataclub @dpdzero
Day 13 #SQLWithIDC In SQL and life, INNER JOIN reminds us: True insight emerges where paths intersect. It’s not about gathering all data— But about finding meaningful matches that matter. Real connection, real value. @indiandataclub @dpdzero
𝗗𝗮𝘆 𝟭𝟴 #SQLWithIDC🚀 Today I explored UNION & UNION ALL — combining multiple queries into one dataset! ✨ 💡Quick Tips: • UNION = no duplicates✅ • UNION ALL = keeps all✅ • Match columns & types • Order only after final result Combine smartly, analyze faster! 🙌
Day 15 of the IDC 21 Days of SQL Challenge organized by @indiandataclub @dpdzero #SQLWithIDC #SQL #sqlbasics
Day 10 of #SQLWithIDC 🚀— CASE statements 💡 Key takeaways: • Use CASE to categorize or create conditional metrics • Always include ELSE (avoid NULLs) • Works in SELECT, ORDER BY, and GROUP BY • First match wins — order matters!
Completed 7 days of the 21 Days SQL Challenge. Staying consistent has helped me strengthen my foundation and approach problems with clarity. Looking forward to learning more and progressing further in the upcoming days. Tagging @dpdzero and @indiandataclub #SQLWithIDC
🚀 Day 1 of the IDC 21 Days SQL Challenge! Started my journey with basics: SELECT, filtering, exploring tables & finding unique values with DISTINCT. Day 1 challenge: List all unique hospital services. Big thanks to IDC & @dpdzero for the supportive community!🙌 #SQLWithIDC
Day 9 of the IDC 21 Days of SQL Challenge organized by @indiandataclub @dpdzero #SQLWithIDC #SQL #sqlbasics
Day 12 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Dived into NULL handling. Today’s challenge: compare weeks “With Event” vs “No Event” and analyze satisfaction + morale. Key learning: NULLs change everything—handle them smartly! #SQLWithIDC
Day 11 #SQLWithIDC 🔶DISTINCT removes duplicates, showing unique rows based on all selected columns. 🔷Use it to clean data and get true unique values. 🔶Remember, for aggregates use GROUP BY, and handle duplicates early for better performance. @indiandataclub @dpdzero
Day 10 of the IDC 21 Days of SQL Challenge organized by @indiandataclub @dpdzero #SQLWithIDC #SQL #sqlbasics
Day 15/21 SQL Challenge I have some commitments tomorrow, so I’m submitting the challenge a day early. I don’t want to break my streak — losing it would hurt more than a breakup! 😄 #SQLwithIDC with @indiandataclub and @dpdzero
Something went wrong.
Something went wrong.
United States Trends
- 1. Texas Tech 25.5K posts
- 2. Messi 155K posts
- 3. Ty Simpson 1,590 posts
- 4. Inter Miami 37.5K posts
- 5. #SECChampionship 2,134 posts
- 6. #MLSCupFinal 1,251 posts
- 7. Slot 117K posts
- 8. Harry Ford 1,105 posts
- 9. Big 12 2,777 posts
- 10. Dawgs 7,663 posts
- 11. Busquets 11.4K posts
- 12. Gunner 5,564 posts
- 13. Liverpool 119K posts
- 14. NDSU 1,205 posts
- 15. Jordi Alba 6,566 posts
- 16. Mariners 2,945 posts
- 17. Ferrer 2,876 posts
- 18. Illinois State 7,789 posts
- 19. Ryan Williams N/A
- 20. #iubb 1,048 posts