你可能会喜欢
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. Chauncey 17.9K posts
- 2. Terry Rozier 15.4K posts
- 3. 5sos 20K posts
- 4. Feds 18.2K posts
- 5. Mafia 69.9K posts
- 6. Gilbert Arenas 1,030 posts
- 7. Good Thursday 28.9K posts
- 8. Malik Beasley 2,192 posts
- 9. Wemby 129K posts
- 10. #thursdayvibes 2,909 posts
- 11. NBA RICO N/A
- 12. Adam Silver 2,627 posts
- 13. Damon Jones N/A
- 14. Mr. Big Shot N/A
- 15. Leanne 1,631 posts
- 16. Blazers 15.1K posts
- 17. The NBA 141K posts
- 18. Shams 3,984 posts
- 19. Friday Eve 1,257 posts
- 20. Poker 15.2K posts
你可能会喜欢
Something went wrong.
Something went wrong.