Subquery Returns Multiple Rows In Comparison?!
Using subquery that returns multiple rows in = comparison crashes! SQL doesn't know which row to use. This breaks subqueries! Watch!
#sql #sqltricks #database #sqltutorial #subqueries #multiplerows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueryerrors #sqlwtf
EXISTS vs IN With NULL Breaks Logic!
EXISTS and IN behave completely differently with NULL! One works, one doesn't. This breaks subquery logic! Watch the chaos!
#sql #sqltricks #database #sqltutorial #existsin #subqueries #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf
EXISTS vs IN with NULLs?!
EXISTS and IN handle NULLs DIFFERENTLY! IN returns NULL when NULL is in the list, EXISTS doesn't. This NULL behavior will cause bugs!
#sql #sqltricks #exists #in #nullhandling #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #subqueries #advancedsql
Correlated Subquery in SELECT?!
Subqueries in SELECT execute for EVERY row! This correlated subquery runs once per row, creating a performance nightmare. This is why queries are slow!
#sql #sqltricks #correlatedsubquery #selectclause #performance #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #subqueries #advancedsql
Correlated Subquery in WHERE?!
Correlated subqueries in WHERE execute for EVERY row! They reference outer query columns, creating a performance nightmare. This is why queries are slow!
#sql #sqltricks #correlatedsubquery #whereclause #performance #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #subqueries #advancedsql
Correlated Subquery With NULL Returns WHAT?!
Correlated subquery with NULL comparison returns something impossible! NULL = NULL in subquery breaks correlation logic! Watch!
#sql #sqltricks #database #sqltutorial #correlatedsubquery #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueries #sqlwtf
๐จ Reminder ๐จJoin us for CrateDB Office Hours tomorrow!
Chat with our engineers about #cursors in #CrateDB, correlated #subqueries, and new aggregation #functions (MIN_BY and MAX_BY) ๐ง๐ปโ๐ป Got another topic you'd like to discuss? Leave a comment below!
๐ March 15th
๐ 5 PM CET/ 11 AM ET
๐ No registration required! Join via Zoom.
Check out our community post for the Zoom link ๐ https://community.crate.io/t/cratedb-office-hours-wednesday-march-15-2023/1399/1
Catch up on related topics by reading our recent #blogposts here ๐ https://crate.io/blog
Donโt miss the opportunity to talk to CrateDB engineers! We are happy to welcome you to our office hours session on March 15, 2023, starting at 5 PM CET/ 11 AM ET. The session is hosted by developer relations and engineering teams and gives you the chance to get advice, ask questions about CrateDB, and learn about the latest product updates and features! For the session on March 15, we prepared a couple of interesting topics with short demos: Cursors in CrateDB Correlated subqueries New aggr...
Donโt miss the opportunity to talk to CrateDB engineers at our next #CrateDB Office Hours ๐
For our next session, we prepared to talk about #cursors in CrateDB, correlated #subqueries, and new #aggregation #functions (MIN_BY and MAX_BY) ๐ค Curious about other CrateDB topics? Leave your suggestions in the comments!
๐ March 15th
๐ 5 PM CET/ 11 AM ET
๐ No need for registration! Join via Zoom
Learn more and get your zoom link in our CrateDB #Community post ๐
https://community.crate.io/t/cratedb-office-hours-wednesday-march-15-2023/1399
Donโt miss the opportunity to talk to CrateDB engineers! We are happy to welcome you to our office hours session on March 15, 2023, starting at 5 PM CET/ 11 AM ET. The session is hosted by developer relations and engineering teams and gives you the chance to get advice, ask questions about CrateDB, and learn about the latest product updates and features! For the session on March 15, we prepared a couple of interesting topics with short demos: Cursors in CrateDB Correlated subqueries New aggr...
PrecisionSQL
zartom
Andy Miller
CrateDB