Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
bolha.us is one of the many independent Mastodon servers you can use to participate in the fediverse.
We're a Brazilian IT Community. We love IT/DevOps/Cloud, but we also love to talk about life, the universe, and more. | Nós somos uma comunidade de TI Brasileira, gostamos de Dev/DevOps/Cloud e mais!

Administered by:

Server stats:

251
active users

bolha.us: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sqlqueries

0 posts0 participants0 posts today
zartom<p>How to Overcome the Listagg Limit of 4000 Characters<br>Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries. <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/LISTAGG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LISTAGG</span></a> <a href="https://mastodon.social/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLQueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLQueries</span></a> <a href="https://mastodon.social/tags/LargeDatasets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LargeDatasets</span></a><br><a href="https://tech-champion.com/database/how-to-overcome-the-listagg-limit-of-4000-characters/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/how</span><span class="invisible">-to-overcome-the-listagg-limit-of-4000-characters/</span></a><br>...</p>
zartom<p>Find the Oldest Even-Numbered Patient Visit Using SQL<br>Learn to extract the Oldest Even Visit SQL record! This tutorial covers various SQL techniques, including CTEs and subqueries, to efficiently retrieve this data. Optimize your queries for speed and handle missing data. <a href="https://mastodon.social/tags/SQLqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLqueries</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/OldestRecord" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OldestRecord</span></a> <a href="https://mastodon.social/tags/EvenVisit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EvenVisit</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a><br><a href="https://tech-champion.com/database/sql-server/find-the-oldest-even-numbered-patient-visit-using-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-server/find-the-oldest-even-numbered-patient-visit-using-sql/</span></a><br>...</p>
Hacker News<p>SQL queries don't start with SELECT (2019)</p><p><a href="https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jvns.ca/blog/2019/10/03/sql-qu</span><span class="invisible">eries-don-t-start-with-select/</span></a></p><p><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/SQLQueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLQueries</span></a> <a href="https://mastodon.social/tags/SQLTips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLTips</span></a> <a href="https://mastodon.social/tags/DatabaseProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseProgramming</span></a> <a href="https://mastodon.social/tags/TechBlog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TechBlog</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a></p>
zartom<p>Troubleshooting DB2 VBA SQL Queries: Setting System Variables and Precision Issues<br>Master DB2 VBA SQL Queries! Learn how system variables impact query results &amp; avoid precision issues. Properly setting session variables is crucial for accurate data retrieval. <a href="https://mastodon.social/tags/DB2VBA" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2VBA</span></a> <a href="https://mastodon.social/tags/SQLqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLqueries</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/TechTips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TechTips</span></a><br><a href="https://tech-champion.com/database/db2luw/troubleshooting-db2-vba-sql-queries-setting-system-variables-and-precision-issues/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/troubleshooting-db2-vba-sql-queries-setting-system-variables-and-precision-issues/</span></a></p>
Python Job Support<p>sql Cheat sheet <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/sqlqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlqueries</span></a> <a href="https://mastodon.social/tags/sqlforbeginners" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlforbeginners</span></a> <a href="https://mastodon.social/tags/sqltraining" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqltraining</span></a> <a href="https://mastodon.social/tags/sqlqueriesforjob" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlqueriesforjob</span></a></p><p>Master the art of SQL with our comprehensive video guide featuring an SQL cheat sheet designed to help you become a pro at ... source</p><p><a href="https://quadexcel.com/wp/sql-cheat-sheet-sql-sqlqueries-sqlforbeginners-sqltraining-sqlqueriesforjob-2/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">quadexcel.com/wp/sql-cheat-she</span><span class="invisible">et-sql-sqlqueries-sqlforbeginners-sqltraining-sqlqueriesforjob-2/</span></a></p>
ExploreLive feeds
About