home.social

#whereclause — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #whereclause, aggregated by home.social.

  1. NULL In WHERE Clause Returns WHAT?!

    STOP SCROLLING! Using NULL in WHERE clause creates something impossible! WHERE col = NULL returns ZERO rows. This breaks all logic! Watch now!

    #sql #sqltricks #database #sqltutorial #nullwhere #sqlquiz #codingchallenge #sqlshorts #sqlbugs #whereclause #sqlwtf #hiddenbehavior

    youtube.com/watch?v=-KaTp1Cv5HA

  2. 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

    youtube.com/watch?v=wQqeMeQuW7c

  3. 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

    youtube.com/watch?v=wQqeMeQuW7c

  4. 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

    youtube.com/watch?v=wQqeMeQuW7c

  5. 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

    youtube.com/watch?v=wQqeMeQuW7c

  6. 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

    youtube.com/watch?v=wQqeMeQuW7c