#sqltricks — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqltricks, aggregated by home.social.
-
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
-
0.1 + 0.2 In SQL = 0.30000000000000004?!
SQL floating point precision is broken! Adding 0.1 + 0.2 creates a number with precision errors. This breaks financial calculations! Watch!
#sql #sqltricks #database #sqltutorial #floatingpoint #precision #sqlquiz #codingchallenge #sqlshorts #sqlbugs #numericprecision #sqlwtf
-
HAVING Filters After GROUP BY?!
HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!
#sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql
-
Window ORDER BY NULLS FIRST - LAST?!
NULLS FIRST and NULLS LAST change window function results! The order of NULLs matters in window functions. This subtle difference will cause bugs!
#sql #sqltricks #windowfunctions #nullsfirst #nullslast #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql
-
Decimal Precision Rounds Numbers?!
DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!
#sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql
-
COUNT(*) vs COUNT(column) Are DIFFERENT?!
COUNT(*) and COUNT(column) behave completely differently with NULLs! One counts NULLs, one doesn't. This breaks aggregate logic! Watch!
#sql #sqltricks #database #sqltutorial #count #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf
-
JOIN With NULL Keys Returns ZERO Rows?!
JOINing tables with NULL keys returns ZERO rows! NULL = NULL in JOIN is FALSE. This breaks all join logic! Watch!
#sql #sqltricks #database #sqltutorial #join #nullkeys #sqlquiz #codingchallenge #sqlshorts #sqlbugs #joins #sqlwtf
-
ROW_NUMBER() OVER (ORDER BY NULL) Does WHAT?!
ROW_NUMBER with ORDER BY NULL creates non-deterministic ordering! All rows get random numbers. This breaks window functions! Watch!
#sql #sqltricks #database #sqltutorial #rownumber #windowfunctions #sqlquiz #codingchallenge #sqlshorts #sqlbugs #ordering #sqlwtf
-
LEN('') vs LEN(NULL) vs LEN(' ') Are DIFFERENT?!
LEN of empty string, NULL, and space are all different! Empty = 0, NULL = NULL, Space = 1. This breaks string length logic! Watch!
#sql #sqltricks #database #sqltutorial #len #stringlength #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringfunctions #sqlwtf
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
TRIM with Different Characters?!
TRIM can remove ANY character! Not just spaces. LEADING, TRAILING, or BOTH. This flexible trimming will clean your data in unexpected ways!
#sql #sqltricks #trim #leading #trailing #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
'10' + 5 In SQL Does WHAT?!
SQL implicit type conversion will shock you! Adding string '10' to number 5 creates something unexpected. This breaks type safety! Watch!
#sql #sqltricks #database #sqltutorial #typeconversion #implicitcast #sqlquiz #codingchallenge #sqlshorts #sqlbugs #typesafety #sqlwtf
-
10 % 0 Modulo By Zero Returns WHAT?!
Modulo by zero in SQL doesn't always crash! Some databases return NULL, others error. This breaks math operations! Watch the chaos!
#sql #sqltricks #database #sqltutorial #modulo #divisionbyzero #sqlquiz #codingchallenge #sqlshorts #sqlbugs #mathoperations #sqlwtf
-
NULL IN (1,2,3) Is NOT What You Think!
Your brain will explode! Checking if NULL is IN a list returns something that makes NO sense. This breaks every query! Watch the chaos!
#sql #sqltricks #database #sqltutorial #nullin #sqlquiz #codingchallenge #sqlshorts #sqlbugs #inclause #sqlwtf #threevaluedlogic
-
Three-Valued Logic: AND - OR With NULL?!
SQL has THREE truth values: TRUE, FALSE, and UNKNOWN (NULL)! AND/OR with NULL creates logic that breaks everything! Watch!
#sql #sqltricks #database #sqltutorial #threevaluedlogic #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #booleanlogic #sqlwtf
-
CHAR vs VARCHAR Padding?!
CHAR PADS with spaces! VARCHAR doesn't. LENGTH() returns different values for same string in CHAR vs VARCHAR. This padding will break comparisons!
#sql #sqltricks #char #varchar #padding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringtypes #advancedsql
-
Conditional Aggregation with CASE?!
CASE inside SUM creates conditional aggregation! You can sum only certain rows based on conditions. This conditional math will transform your data!
#sql #sqltricks #case #sum #conditionalaggregation #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql
-
GROUP BY NULLs Are Treated As ONE?!
GROUP BY treats all NULLs as the same group! Multiple NULL rows get grouped together. This breaks grouping logic! Watch now!
#sql #sqltricks #database #sqltutorial #groupby #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #grouping #sqlwtf
-
NULL = NULL Is FALSE In SQL?!
STOP SCROLLING! Comparing NULL to NULL in SQL returns FALSE, not TRUE! This breaks every assumption about equality. Your mind will explode! Watch now!
#sql #sqltricks #database #sqltutorial #sqlweird #nullcomparison #sqlquiz #codingchallenge #sqlshorts #sqlwtf #databasequeries #sqlbugs
-
COALESCE(NULL, NULL, NULL) Returns WHAT?!
COALESCE with all NULLs returns something that defies logic! This function is supposed to return first non-NULL but what if all are NULL? Watch!
#sql #sqltricks #database #sqltutorial #coalesce #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #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
-
Date Arithmetic with Leap Year?!
Leap years BREAK date math! February 28 + 1 day = February 29 in leap years, March 1 in non-leap years. This edge case will cause bugs!
#sql #sqltricks #datearithmetic #leapyear #dateadd #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datefunctions #advancedsql
-
LAG - LEAD Default Value Trap?!
LAG and LEAD have DEFAULT values! When there's no previous/next row, they return the default. This hidden parameter will surprise you!
#sql #sqltricks #lag #lead #defaultvalue #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #windowfunctions #advancedsql
-
NULLIF and COALESCE Chain?!
NULLIF and COALESCE can be CHAINED! NULLIF converts to NULL, COALESCE converts from NULL. This transformation chain will surprise you!
#sql #sqltricks #nullif #coalesce #functionchaining #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #nullhandling #advancedsql
-
Window PARTITION BY Changes Results?!
PARTITION BY creates separate windows! Each partition has its own running sum. This partitioning will change your aggregation results!
#sql #sqltricks #partitionby #windowfunctions #runningsum #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #advancedsql
-
DATE_FORMAT with Edge Cases?!
DATE_FORMAT has HUNDREDS of format codes! %j is day of year, %W is weekday name. This formatting language will confuse you!
#sql #sqltricks #dateformat #formatcodes #dateformatting #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datefunctions #advancedsql
-
JSON Path Expressions Extract Data?!
JSON_EXTRACT uses PATH syntax! The $ symbol means root, . means property access. This JSON path language will confuse you!
#sql #sqltricks #jsonextract #jsonpath #jsonunquote #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #jsonfunctions #advancedsql
-
String Collation Changes Comparison?!
Collation CHANGES string comparison! Case-insensitive collation makes 'A' = 'a'. This hidden setting will break your WHERE clauses!
#sql #sqltricks #collation #stringcomparison #casesensitivity #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #stringfunctions #advancedsql
-
Self-Join with Aliases Trap?!
Self-joins need DIFFERENT aliases! Same table, different names. The join condition creates relationships within the same table. This will confuse you!
#sql #sqltricks #selfjoin #aliases #tablealiases #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #joins #advancedsql
-
NULLIF(5, 5) Returns NULL?!
NULLIF with same values returns NULL instead of the value! This function behavior will break your brain. Watch the reveal!
#sql #sqltricks #database #sqltutorial #nullif #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #sqlwtf
-
NTH_VALUE Gets Specific Position?!
NTH_VALUE extracts the Nth value from window! It's like array indexing for window functions. This positional access will surprise you!
#sql #sqltricks #nthvalue #windowfunctions #positionalaccess #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #advancedsql
-
Empty String '' vs NULL Are DIFFERENT?!
SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!
#sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf
-
CTE Referenced Multiple Times?!
CTEs can be referenced MULTIPLE times! The same CTE appears in different parts of the query. This reusability will simplify complex queries!
#sql #sqltricks #cte #withclause #multiplereferences #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #commontableexpressions #advancedsql
-
Recursive CTE Termination Condition?!
Recursive CTEs can loop FOREVER! The termination condition is CRITICAL. One wrong condition and your query hangs. This is how infinite loops happen in SQL!
#sql #sqltricks #recursivecte #withrecursive #termination #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #cterecursion #advancedsql
-
String Functions With NULL Return NULL?!
LEN, SUBSTRING, and other string functions with NULL return NULL, not error! This breaks string processing logic! Watch the reveal!
#sql #sqltricks #database #sqltutorial #stringfunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringoperations #sqlwtf
-
Date Functions With NULL Return NULL?!
DATEADD and DATEDIFF with NULL return NULL instead of error! Date arithmetic with NULL breaks all date logic! Watch now!
#sql #sqltricks #database #sqltutorial #datefunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #dateoperations #sqlwtf
-
Window Frame UNBOUNDED?!
UNBOUNDED PRECEDING means ALL previous rows! UNBOUNDED FOLLOWING means ALL future rows. This creates running totals across the entire window!
#sql #sqltricks #unbounded #preceding #following #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #windowframes #advancedsql
-
NOT IN With NULL Returns FALSE Always?!
NOT IN with NULL in the list ALWAYS returns FALSE! Even if value is not in list, NULL breaks NOT IN logic completely! Watch!
#sql #sqltricks #database #sqltutorial #notin #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #setoperations #sqlwtf
-
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
-
HAVING With NULL Comparison Breaks Logic!
HAVING clause with NULL comparison returns ZERO rows! HAVING col = NULL never matches. This breaks aggregate filtering! Watch!
#sql #sqltricks #database #sqltutorial #having #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #aggregatefiltering #sqlwtf