Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
nerdculture.de is one of the many independent Mastodon servers you can use to participate in the fediverse.
Be excellent to each other, live humanism, no nazis, no hate speech. Not only for nerds, but the domain is somewhat cool. ;) No bots in general. Languages: DE, EN, FR, NL, ES, IT

Administered by:

Server stats:

1.2K
active users

nerdculture.de: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.6

#sqlqueries

2 posts1 participant0 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>
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>
Franck Pachot<p>🐘 Interesting case of prepared statement going generic with bad consequences <br>---<br>RT @Mirakl<br>💡New on our Tech Blog: Fabien Chebel, software architect at Mirakl, shares how the team uncovered a <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> feature no one knew existed while investigating slow <a href="https://mastodon.social/tags/SQLqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLqueries</span></a>. Read more ⬇️<br><a href="https://bit.ly/3R7Jq08" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="">bit.ly/3R7Jq08</span><span class="invisible"></span></a><br><a href="https://twitter.com/Mirakl/status/1618631105787084802" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">twitter.com/Mirakl/status/1618</span><span class="invisible">631105787084802</span></a></p>
ExploreLive feeds
About