Daily SQL Snippets
@SqlSnippets
SQL lovers sharing loveable SQL every day of the year. Submit your snippets: http://sql-snippets.count.co Tag us to share snippets to feature!
Вам может понравиться
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. INCOGNITO 4,171 posts
- 2. Cynthia 86.9K posts
- 3. #WorldKindnessDay 12.9K posts
- 4. #NXXT_EarningReport N/A
- 5. Katie Couric 3,462 posts
- 6. CarPlay 2,053 posts
- 7. Massie 87.1K posts
- 8. Larry Brooks 2,754 posts
- 9. #LoveDesignEP7 115K posts
- 10. GRABFOOD LOVES LINGORM 973K posts
- 11. Encyclopedia Galactica 4,576 posts
- 12. RIN AOKBAB BEGIN AGAIN 115K posts
- 13. Bonhoeffer 2,136 posts
- 14. Tommy James N/A
- 15. $NXXT 1,417 posts
- 16. #thursdayvibes 3,917 posts
- 17. Black Mirror 3,147 posts
- 18. Bongino 8,523 posts
- 19. Good Thursday 38.8K posts
- 20. Michael Burry 11.8K posts
Вам может понравиться
-
Developer Nation Global Community
@devnationworld -
SQL Daily
@sqldaily -
DB-Engines
@DBEngines -
Modern SQL
@ModernSQL -
SQL.ProductManager.Oracle.Databases
@thatjeffsmith -
DrawSQL
@drawSQL -
Maria Colgan
@SQLMaria -
Ginger Grant
@DesertIsleSQL -
Mohamed Al Salti 🇵🇸
@m_salti_ -
Marco “Papel”
@Papel_Arts -
Jad Eid
@Jad_W_Eid
Something went wrong.
Something went wrong.