내가 좋아할 만한 콘텐츠
What I learned from this snippet: 1 - some years have 53 weeks (2022 👀) 2 - and that really messes up fiscal calendar calculations 3 - but, with a clever bit of code, it can be fixed! sql-snippets.count.co/t/advanced-dat…
Did you know #Snowflake has extensive support for manipulation of JSON strings? Check out an interactive example which demonstrates parsing and accessing fields here: sql-snippets.count.co/t/parse-json/2…
Handling dates in #BigQuery? You'll want to see this pair of snippets from user stretch for creating views packed with useful date dimensions: sql-snippets.count.co/t/basic-date-d… sql-snippets.count.co/t/advanced-dat…
SQL Snippets-Crowdsourcing SQL Queries "A curated collection of helpful and reusable SQL snippets" #SQL #Database #Postgresql #SQLServer cutt.ly/JQ9SViR @SqlSnippets @tbrownlow3 @databasestar @WebOpsDaily @PostgresWeekly @SQLShack @CuratedSQL @FriedholdMatz @DatabaseDaily
This #SQLServer snippet isn't just a snippet...it's also a great refresher on the theory behind compound growth rates 🧠 📈 Learn how to model them in SQL: sql-snippets.count.co/t/compound-gro… #SQL
Anyone else always forgetting the syntax for formatting your dates? This #BigQuery Date and Time formatting cheat sheet snips the most common formatting strings for quick access next time you need them 🙌 sql-snippets.count.co/t/formatting-d… #SQL
Missing the "remove duplicates" button from Excel? Use this snippet to drop duplicate rows in @PostgreSQL & start your analysis off on the right foot sql-snippets.count.co/t/removing-dup… #SQL @planetpostgres
Learn how to use #bigquery array and hash functions to generate uniform random data with this clever snippet! sql-snippets.count.co/t/generate-uni… #SQL
Turn a stringified array of values into a nice, tidy column using @PostgreSQL 's REGEX_SPLIT_TO_TABLE function sql-snippets.count.co/t/split-column… #SQL
Levenshtein distance is a great way to compare two strings but can be nearly impossible if your DB doesn't have a built-in function. Copy this snippet next time you want to try it out in @MySQL , or save it as a UDF for even quicker access! sql-snippets.count.co/t/levenshtein-… #SQL #NLP
Learn how the RANK window function can help finding the first row in a group, using an example written for @SQLServer sql-snippets.count.co/t/find-the-fir…
Did you know @SnowflakeDB has a built-in function to help you parse a URL? This snippet shows us how to use PARSE_URL to transform a messy URL string into meaningful data (without regex!) sql-snippets.count.co/t/parse-url/79 #SQL #snowflake #DataScience
Many dialects have a LAST_DATE function to find the last day of a given month. This snippet helps us get that same functionality in #BigQuery 🙌 #SQL
Outlier detection isn't just for your stats class. This snippet shows 3 ways to identify outliers in #snowflake sql-snippets.count.co/t/outlier-dete… #SQL #DataScience #Stats #FridayFun
Does your regex knowledge disappear every time you need to use it? Bookmark this #Postgres snippet for the next time you need to parse URLs: sql-snippets.count.co/t/parse-url/10…
See how to use analytic functions in #bigquery to do the classic but essential Year over Year % difference: sql-snippets.count.co/t/year-over-ye…
United States 트렌드
- 1. RIP Beef 1,166 posts
- 2. SNAP 638K posts
- 3. #HardRockBet 4,435 posts
- 4. Jamaica 94.8K posts
- 5. Friendly 54.9K posts
- 6. McCreary 2,646 posts
- 7. MRIs 3,078 posts
- 8. #IDontWantToOverreactBUT 6,541 posts
- 9. Hurricane Melissa 56.6K posts
- 10. 53 Republicans 2,005 posts
- 11. $ZOOZ 5,541 posts
- 12. #ChelleyxTrueReligion 3,770 posts
- 13. $NXXT 3,562 posts
- 14. John Dickerson 1,434 posts
- 15. #MondayMotivation 44.5K posts
- 16. Rand 31.8K posts
- 17. Jack DeJohnette 3,314 posts
- 18. #NationalBlackCatDay 3,536 posts
- 19. Sports Equinox 8,373 posts
- 20. Berghain 44.8K posts
내가 좋아할 만한 콘텐츠
Something went wrong.
Something went wrong.