Meta tags:
description=Better Decisions === Faster Stats;

Headings (most frequently used words):

sql, and, please, share, functions, stats, views, database, patterns, logic, bitcoin, decision, window, ranking, running, totals, lag, lead, moving, averages, materialized, designing, securing, optimizing, reporting, transactions, concurrency, acid, isolation, levels, locking, deadlocks, safe, subqueries, ctes, correlated, queries, exists, derived, tables, common, table, expressions, string, text, cleaning, slicing, searching, splitting, concatenation, stored, procedures, triggers, server, side, control, flow, automation, set, operations, conditional, union, case, null, handling, advanced, posts, pagination, blog, address, wallet, latest, book, books, by, ajay, ohri, on, fb, archives,

Text of the page (most frequently used words):
and (149), the (140), for (63), can (62), sql (49), window (45), while (36), with (34), rows (33), share (29), functions (28), #database (28), when (27), are (27), such (26), null (25), new (23), row (23), august (22), data (22), opens (21), from (21), that (20), values (19), view (18), table (18), may (17), presentation (17), views (17), january (16), set (16), true (16), result (16), should (16), also (16), march (15), analytics (15), operations (15), query (15), value (15), without (15), december (14), june (14), july (14), facebook (14), linkedin (14), not (14), into (14), order (14), materialized (14), this (13), february (13), logic (13), queries (13), but (13), than (13), one (13), because (13), transactions (13), 2008 (12), september (12), 2009 (12), 2010 (12), 2011 (12), 2012 (12), 2013 (12), 2014 (12), 2015 (12), like (12), april (11), october (11), november (11), 2016 (11), 2017 (11), 2018 (11), 2026 (11), provide (11), which (11), level (11), ctes (11), case (10), better (10), same (10), rather (10), useful (10), using (10), transaction (10), text (10), com (9), leave (9), union (9), results (9), inside (9), column (9), through (9), based (9), therefore (9), important (9), reporting (9), where (9), triggers (9), they (9), making (9), each (9), isolation (9), required (8), comment (8), loading (8), decision (8), stats (8), 2020 (8), patterns (8), categories (8), loop (8), generally (8), first (8), common (8), running (8), more (8), only (8), about (7), 2019 (7), conditional (7), handling (7), tags (7), posted (7), aviral (7), gupta (7), author (7), please (7), https (7), docs (7), google (7), 2pacx (7), pub (7), start (7), delayms (7), 10000 (7), multiple (7), expressions (7), allow (7), returns (7), columns (7), source (7), ordering (7), produce (7), make (7), safe (7), cleaning (7), then (7), every (7), exists (7), group (7), particularly (7), controlled (7), update (7), index (7), subqueries (7), expensive (7), analytical (7), refresh (7), over (7), write (6), decisionstats (6), requires (6), business (6), duplicate (6), require (6), different (6), used (6), aggregate (6), all (6), prevent (6), provides (6), non (6), outer (6), create (6), performance (6), use (6), distinct (6), select (6), side (6), control (6), function (6), allows (6), between (6), single (6), another (6), audit (6), after (6), instead (6), correlated (6), derived (6), calculations (6), its (6), concurrency (6), unique (6), frame (6), partition (6), join (5), other (5), whereas (5), both (5), operation (5), position (5), joins (5), structure (5), tables (5), conditions (5), top (5), simple (5), must (5), behaviour (5), becomes (5), predicate (5), these (5), sorting (5), updates (5), indexed (5), prevents (5), except (5), stored (5), server (5), always (5), statement (5), statements (5), across (5), work (5), locks (5), complex (5), application (5), once (5), searching (5), recursive (5), subquery (5), makes (5), current (5), ranking (5), totals (5), month (5), interviews (4), 2021 (4), page (4), combine (4), directly (4), number (4), determines (4), combined (4), expression (4), return (4), comparisons (4), comparison (4), several (4), practical (4), procedural (4), code (4), records (4), performs (4), key (4), reliable (4), how (4), behave (4), become (4), recommends (4), procedures (4), exception (4), scalar (4), indexes (4), entire (4), long (4), maintenance (4), commit (4), record (4), them (4), most (4), never (4), retry (4), layer (4), execute (4), per (4), skip (4), multi (4), string (4), concatenation (4), explicit (4), postgresql (4), appropriate (4), normalised (4), include (4), user (4), aggregates (4), execution (4), cte (4), nested (4), insert (4), customer (4), read (4), locking (4), changes (4), reads (4), deterministic (4), stock (4), security (4), moving (4), gaps (4), sign (3), 2023 (3), next (3), way (3), sets (3), default (3), present (3), errors (3), addresses (3), against (3), matching (3), matters (3), involving (3), tools (3), semantics (3), together (3), fallback (3), perform (3), missing (3), highlights (3), straightforward (3), large (3), datasets (3), efficient (3), zero (3), expressive (3), easier (3), count (3), coalesce (3), full (3), unknown (3), flow (3), automation (3), assumptions (3), consistent (3), state (3), gives (3), named (3), unexpected (3), affected (3), before (3), what (3), trails (3), example (3), inserts (3), old (3), transformations (3), production (3), repeatable (3), possible (3), locked (3), suitable (3), reusable (3), step (3), choosing (3), difficult (3), rollback (3), splitting (3), positions (3), fixed (3), often (3), processing (3), characters (3), collapsing (3), meaning (3), range (3), separated (3), need (3), correctness (3), whether (3), equal (3), input (3), storing (3), immediately (3), original (3), replace (3), right (3), length (3), computed (3), filtering (3), pushdown (3), atomic (3), evaluated (3), acid (3), levels (3), deadlocks (3), concurrent (3), short (3), concurrently (3), lock (3), does (3), exist (3), systems (3), dashboards (3), recent (3), time (3), dependencies (3), tenant (3), faster (3), lag (3), lead (3), averages (3), groups (3), ties (3), cohort (3), sort (3), row_number (3), last_value (3), name (2), email (2), reader (2), report (2), content (2), log (2), subscribed (2), subscribe (2), already (2), wordpress (2), blog (2), org (2), 2024 (2), users (2), bitcoin (2), advanced (2), branching (2), simply (2), elimination (2), compatible (2), types (2), output (2), names (2), final (2), applies (2), confusing (2), related (2), adding (2), change (2), counts (2), problem (2), condition (2), unmatched (2), three (2), evaluate (2), why (2), especially (2), list (2), equality (2), division (2), aggregation (2), transforming (2), buckets (2), optional (2), two (2), typically (2), understanding (2), exactly (2), chains (2), has (2), nullif (2), else (2), intersect (2), sum (2), pgsql (2), variables (2), loops (2), returning (2), parameterised (2), joined (2), volatility (2), access (2), remain (2), within (2), reading (2), calls (2), information (2), immutable (2), approach (2), usually (2), far (2), transformation (2), dataset (2), deliberate (2), failures (2), tasks (2), batches (2), deck (2), demonstrates (2), job (2), holding (2), keep (2), ahead (2), validate (2), well (2), suited (2), integrity (2), rules (2), external (2), queues (2), kept (2), efficiently (2), version (2), stable (2), object (2), role (2), automatically (2), maintain (2), slicing (2), parsing (2), according (2), forgetting (2), introduce (2), delimited (2), remove (2), width (2), repeated (2), particular (2), care (2), part (2), components (2), mechanism (2), normal (2), tree (2), searches (2), wildcard (2), workloads (2), trigram (2), search (2), regular (2), simpler (2), sufficient (2), expanded (2), aggregated (2), although (2), comma (2), similarly (2), lists (2), depend (2), keeping (2), predicates (2), being (2), collation (2), character (2), robust (2), review (2), aditi (2), lower (2), upper (2), string_agg (2), adi (2), split_part (2), substring (2), essential (2), databases (2), measures (2), distinction (2), repeat (2), balance (2), appear (2), valuable (2), summaries (2), structured (2), plans (2), standard (2), allowing (2), depth (2), cycle (2), powerful (2), many (2), day (2), problems (2), filter (2), rank (2), ways (2), intermediate (2), engines (2), even (2), independent (2), comparing (2), average (2), own (2), foundation (2), deeply (2), logical (2), clause (2), meaningful (2), ensures (2), constraints (2), observe (2), committed (2), boundaries (2), contention (2), ordinary (2), applications (2), depends (2), workers (2), wait (2), writes (2), race (2), check (2), pattern (2), enforced (2), idempotency (2), keys (2), request (2), preferable (2), relying (2), transfer (2), verify (2), independently (2), design (2), designing (2), securing (2), optimizing (2), readers (2), existing (2), incremental (2), rollup (2), inspected (2), definitions (2), expose (2), mistakes (2), objects (2), definition (2), cascade (2), base (2), preserving (2), plan (2), interface (2), option (2), filtered (2), underlying (2), their (2), defines (2), detail (2), assigns (2), deduplication (2), offset (2), retention (2), specification (2), max (2), min (2), decisions (2), website, comments, collapse, bar, manage, subscriptions, site, privacy, have, account, now, 427, subscribers, slideshow, javascript, 2007, 2022, archives, cloud, computing, python, books, ajay, ohri, sas, latest, book, 12fxl4og4mqtzt6prz1lkcmqq6ddgjk4yg, wallet, address, 366, 937, hits, 369, posts, pagination, 1vsyt01y1aizh5l8l, 0glwfi2y, 7rzz1n, gklbrhf7ys, shixvss4iphdhhj3gw, vertically, express, combines, removes, duplicates, appends, unnecessary, absent, second, oracle, uses, latter, matched, stack, horizontally, attributes, fan, out, supports, searched, evaluates, arbitrary, boolean, bottom, compares, branch, wins, omitted, branches, valued, normally, explains, replaced, qualifying, controlling, argument, converts, specified, support, nullable, features, enable, requiring, portable, static, pivots, quarters, separate, implement, custom, priority, age, revenue, construct, filters, reconciliation, directions, reveals, either, system, difference, paired, labelled, showing, extra, differing, consideration, hashing, append, anti, sometimes, alternative, states, removal, explicitly, parenthesise, mixed, higher, precedence, narrow, broad, ratios, idiom, supplying, finally, remember, ignores, principles, predictable, heavy, substantially, reason, false, having, minus, 1vsrilalmimxkyz_nyzqkrxix_nx_zlz3xbl2g, q7fl7yy1h, yyybcsraocg6a9cbq, implemented, languages, accepts, parameters, much, composed, communicates, indicates, inputs, permits, declaring, accurately, planner, participate, adds, blocks, however, strongly, emphasises, slower, likewise, abort, clear, message, caught, recovery, genuinely, broadly, swallowing, blanket, dangerous, hide, chunked, archival, 000, monitor, committing, chunks, enormous, helps, logging, growth, manageable, form, modify, actually, happened, captures, deletes, jsonb, snapshots, lesson, knowing, belongs, bypassed, strong, candidate, bulk, close, frequently, changing, workflows, services, observability, matter, process, tested, assertion, deployed, migrations, instrumented, explain, analyze, current_user, tg_op, get, diagnostics, others, unique_violation, raise, volatile, called, computations, procedure, invoked, designed, batch, again, response, events, enforcement, correct, becoming, unnecessarily, call, 1vqraz4xnlk3rfxqktdd0wo8vt1v8uosw3dz6b_v6m0rd9lgjymtwqm0, auyfhehpq, silent, off, extract, region, locate, delimiters, dynamically, clearer, consistently, codes, prepare, imported, unwanted, handles, retaining, digits, phone, numbers, whitespace, around, operator, propagates, component, concatenated, treats, empty, strings, separator, supply, weakest, satisfies, requirement, prefix, leading, scan, contains, assisted, natural, language, document, validation, extraction, replacement, cpu, bound, resulting, trimmed, analysed, technique, denormalised, imports, repeatedly, represented, child, rebuild, ordered, placed, removed, heavily, indexable, specific, wrapping, plain, unless, corresponding, solutions, affects, made, considering, pitfalls, propagation, treating, leaving, unescaped, padding, relationships, workflow, normalise, deleting, bad, deduplicate, preserve, char, unnest, string_to_array, to_tsquery, to_tsvector, concat_ws, concat, regexp_replace, rpad, lpad, translate, trim, left, textual, relational, handle, measurement, bytes, multibyte, byte, specialised, manipulation, folded, representation, permanently, destroying, chr, ascii, reverse, octet_length, initcap, char_length, 1vrq7puh3hhepqabw3zp7sp1ne8x5d95wilbs5yk3xvklsl2oiqsuyg7frog, lo67w, ultimately, readability, membership, tests, grouped, alongside, detailed, optimization, replacing, pre, compute, repeating, optimizer, opportunity, generate, iteration, hierarchical, anchor, term, connected, traverse, organizational, charts, category, trees, bills, material, graph, paths, carrying, additional, ancestry, limit, guard, infinite, recursion, expressed, chained, progressively, enrich, clearly, stages, elegant, inline, temporary, transforms, down, pipeline, feeds, modern, optimize, offers, inlined, writable, take, further, enabling, archiving, delete, solve, kinds, uncorrelated, global, references, logically, purchase, rewritten, testing, existence, retrieving, superior, stops, soon, found, writing, maintainable, solving, developers, decompose, steps, extend, idea, giving, debug, 1vraydsa4uqmbs4dxcsihquuwbqrr2ouiuxcoyhegl8whepj74dwmcritkgswyalqg, grouping, unit, properties, describe, guarantees, dependable, atomicity, succeed, none, consistency, preserves, controls, durability, survive, enables, partial, larger, equally, retain, increase, versions, cleaned, simultaneously, anomalies, dirty, phantom, lost, skew, determine, effects, prevented, commonly, oltp, snapshot, reports, strongest, though, were, executed, conflicting, aborted, exact, differs, assume, universal, selected, until, ends, preventing, modifying, cases, modification, fail, waiting, ignore, claimed, backed, occur, defence, acquire, chooses, deadlock, victim, avoiding, classic, clients, attempt, uniqueness, resolve, atomically, associated, retries, harmless, ops, payments, background, status, let, claim, jobs, blocking, optimistic, lived, interactions, pessimistic, high, inventory, decrements, central, principle, timing, opened, late, network, money, accounts, debit, credit, cannot, monitoring, blocked, idle, sessions, turn, intermittent, bugs, deliberately, merge, conflict, nowait, items, serializable, savepoint, begin, 1vttyhijxeolihpj7er8mg5pggkoawnw0fpin2obbpfjixcts5mcvmpks7cpxqbnbq, effective, generated, millions, serve, recomputes, block, continue, accessing, during, recomputation, too, recompute, upsert, cost, primarily, changed, historical, operational, discipline, schema, freshness, fields, logs, creating, excessive, layers, refreshing, availability, hiding, exclusively, checking, you, tolerate, scheduled, refreshes, bounded, refreshed_at, good, layering, building, increasingly, deep, separating, model, standardising, entity, joining, entities, consumed, exports, keeps, understandable, stage, testable, dropping, dependent, caution, pushed, act, updatable, would, outside, defining, route, perspective, approved, restrict, permissions, revoked, certain, techniques, leaking, defined, stronger, enforcing, security_barrier, physically, store, calling, computation, performed, whenever, queried, contrast, behaves, quickly, fresh, abstraction, some, staleness, acceptable, 1vt8udq51jomydvairzi0wvcsh4at5tqwthzjd5zbhocm0oi45r6jmq51tp1lhygmg, calculate, unlike, reduces, smaller, divides, establishes, sequence, included, calculation, percentage, total, rankings, assign, differently, sequential, selecting, tied, leaves, competition, style, standings, ranks, tiers, distributes, approximately, quartiles, deciles, cohorts, critical, determinism, assignments, executions, tiebreaker, primary, added, calculated, compare, neighbouring, constructing, self, retrieves, earlier, looks, ideal, period, event, retrieve, edges, end, causing, operate, windows, cumulative, summary, seven, frames, physical, treated, peers, wrong, including, islands, sessionisation, identifies, arithmetic, windowed, supplies, population, denominator, largely, combination, completed, pass, sorted, reusing, eliminate, reduce, tuning, extending, assuming, define, precisely, choose, intentionally, windowagg, cust_id, avg, first_value, ntile, dense_rank, menu,

Text of the page (random words):
tables and common table expressions sql string functions text cleaning slicing searching splitting and concatenation sql string functions are essential for cleaning transforming parsing and searching textual data inside relational databases functions such as length char_length upper lower and initcap handle measurement and case transformation while octet_length measures bytes rather than characters and becomes important with multibyte data the distinction matters because character length and byte length are not always the same sql also provides functions such as reverse repeat ascii and chr for specialised text manipulation for reliable comparisons the presentation recommends storing the original value while using a folded or normalised representation for comparison rather than permanently destroying the source text parsing text becomes straightforward when substring left right position and split_part are used according to the structure of the data sql string positions are generally 1 based so forgetting this can introduce silent off by one errors substring can extract a fixed region or work together with position to locate delimiters dynamically while split_part is often clearer when processing consistently delimited values such as order codes or email addresses cleaning functions then prepare imported data for reliable comparison trim replace and translate remove unwanted characters lpad and rpad create fixed width values and regexp_replace handles more complex transformations such as retaining only digits in phone numbers or collapsing repeated whitespace concatenation requires particular care around null values the operator propagates null meaning that a single missing component can make an entire concatenated result null concat treats null values as empty strings while concat_ws is especially useful for addresses and other multi part values because it inserts the separator only between non null components coalesce provides another explicit way to supply fallback values for searching the presentation recommends using the weakest mechanism that satisfies the requirement equality can use a normal b tree index prefix searches such as like adi can use an index while a leading wildcard such as like adi generally prevents a normal b tree range scan for postgresql workloads trigram indexes can make contains searches index assisted while full text search with to_tsvector and to_tsquery is more appropriate for natural language document search regular expressions provide more expressive validation extraction and replacement than like but they are generally cpu bound and should not be used when a simpler indexed predicate is sufficient the deck also demonstrates how delimited text can be expanded into rows using string_to_array and unnest after which the resulting values can be trimmed analysed joined or aggregated with string_agg although this technique is useful for cleaning denormalised imports repeatedly splitting a comma separated column is a sign that the data may be better represented in a normalised child table similarly string_agg can rebuild ordered lists across rows with order by placed inside the aggregate and distinct used when repeated values need to be removed performance and correctness depend heavily on keeping text predicates indexable and understanding database specific behaviour wrapping an indexed column in functions such as upper or lower can prevent a plain index from being used unless a corresponding expression index exists postgresql expression indexes and trigram indexes provide practical solutions collation also affects case comparison sorting and other text semantics so assumptions about whether values such as aditi and aditi are equal should never be made without considering the database and column collation common pitfalls include null propagation in concatenation treating character positions as zero based leaving wildcard characters unescaped in user input unexpected char padding and storing comma separated lists instead of normalised relationships a robust text processing workflow is therefore to normalise first validate without immediately deleting bad records deduplicate using a normalised key and preserve the original data for review https docs google com presentation d e 2pacx 1vqraz4xnlk3rfxqktdd0wo8vt1v8uosw3dz6b_v6m0rd9lgjymtwqm0 auyfhehpq pub start true loop true delayms 10000 please share share on linkedin opens in new window linkedin share on facebook opens in new window facebook share on x opens in new window x like loading author aviral gupta posted on august 9 2026 categories analytics tags analytics data sql leave a comment on sql string functions text cleaning slicing searching splitting and concatenation sql stored procedures functions triggers server side logic control flow and database automation stored procedures functions and triggers allow application logic to execute directly inside the database but each object has a distinct role a function returns a value or table and can be called from select where or joins making it suitable for reusable computations and parameterised reporting a procedure is invoked with call and is designed for multi step maintenance or batch operations where transaction control such as commit and rollback is required triggers are different again they execute automatically in response to database events and are particularly useful for integrity enforcement audit trails and controlled row level transformations choosing the correct object prevents server side code from becoming unnecessarily complex or difficult to maintain sql functions can be implemented as simple sql expressions or with procedural languages such as pl pgsql when variables branching loops or exception handling are required a scalar function accepts parameters and returns one value while a table returning function can behave much like a parameterised view that can be joined and composed with other queries function volatility is also important because it communicates assumptions about how results behave immutable indicates that the same inputs always produce the same result without table access stable allows results to remain consistent within a statement while reading database state and volatile permits results to change between calls declaring volatility accurately gives the query planner more information and can allow immutable functions to participate in expression indexes pl pgsql adds procedural control flow through variables if statements loops records and exception blocks however the presentation strongly emphasises a set based first approach a loop that performs an operation row by row is usually far slower than a single sql statement that performs the same transformation across the entire dataset exception handling should likewise be deliberate raise exception can abort an operation with a clear message while named conditions such as unique_violation can be caught when recovery is genuinely required broadly swallowing errors with a blanket when others then null is dangerous because it can hide failures and leave data in an unexpected state procedures become particularly useful for long running maintenance tasks because they can commit work between batches the deck demonstrates chunked archival using batches of 10 000 rows for update skip locked and get diagnostics to monitor affected rows committing between chunks prevents a maintenance job from holding one enormous transaction and helps keep locks and write ahead logging growth manageable triggers provide another form of server side automation before row triggers can modify or validate new before a row is stored while after row triggers can record what actually happened making them well suited to audit trails the presentation s audit example captures inserts updates and deletes using tg_op current_user and jsonb snapshots of the old and new rows the most important lesson is not simply how to write server side sql but knowing when it belongs in the database logic that must never be bypassed such as integrity rules and audit trails is a strong database side candidate as are set based transformations and bulk maintenance close to the data frequently changing business rules workflows involving external services retry queues and complex application behaviour are generally better kept in the application layer performance and observability also matter row level triggers execute once per affected row while set based statements can process large datasets far more efficiently production database code should therefore be version controlled tested with assertion queries deployed through repeatable migrations instrumented with tools such as explain analyze and kept as set based as possible https docs google com presentation d e 2pacx 1vsrilalmimxkyz_nyzqkrxix_nx_zlz3xbl2g q7fl7yy1h yyybcsraocg6a9cbq pub start true loop true delayms 10000 please share share on linkedin opens in new window linkedin share on facebook opens in new window facebook share on x opens in new window x like loading author aviral gupta posted on august 9 2026 categories analytics tags analytics data sql leave a comment on sql stored procedures functions triggers server side logic control flow and database automation sql set operations conditional logic union case null handling and advanced sql patterns sql set operations provide a way to combine the results of multiple queries vertically while conditional expressions allow sql to express branching logic directly inside a query union combines result sets and removes duplicates whereas union all simply appends the rows and is generally the better default when duplicate elimination is unnecessary intersect returns rows present in both result sets while except returns rows present in the first result but absent from the second oracle uses minus for the latter operation set operations require the same number of columns with compatible types and columns are matched by position rather than name the first select determines the output column names while a final order by applies to the combined result a common source of sql errors is confusing set operations with joins set operations stack rows with the same structure whereas joins combine related tables horizontally by adding attributes and can change row counts through fan out case addresses a different problem it returns a value based on conditions and can therefore be used in select where group by order by having and aggregate expressions sql supports both searched case which evaluates arbitrary boolean conditions from top to bottom and simple case which compares one expression against multiple values the first matching branch wins so condition ordering matters if else is omitted unmatched rows produce null and all branches must return compatible types sql s handling of null is based on three valued logic a condition can evaluate to true false or unknown comparisons involving null normally produce unknown which explains why null null is not true and why null should be replaced with is null this behaviour becomes especially important with not in because a null in the comparison list can make the predicate evaluate to unknown and prevent rows from qualifying sql provides several tools for controlling this behaviour coalesce returns the first non null argument nullif converts a specified value into null and is distinct from provides null safe equality semantics together these functions support fallback values data cleaning safe division outer join reporting and comparisons involving nullable columns these features also enable several practical sql patterns without requiring procedural code conditional aggregation with sum case can create portable static pivots transforming categories such as quarters into separate columns case can implement custom business priority sorting create age or revenue buckets perform conditional updates and construct optional filters for data reconciliation running except in both directions reveals rows missing from either system the two difference sets can then be combined and paired with a full outer join to produce a labelled report showing missing extra or differing records the presentation also highlights an important performance consideration union and except require duplicate elimination typically through sorting or hashing while union all performs a straightforward append for large datasets an indexed not exists anti join can sometimes be a more efficient alternative to except the key to reliable sql set and conditional logic is understanding exactly how rows values and null states behave use union all when duplicate removal is not required explicitly parenthesise mixed set operation chains because intersect has higher precedence than union and except order case conditions from narrow to broad and provide an else when an unmatched result should not become null for safe ratios the presentation recommends the idiom coalesce a nullif b 0 0 which prevents division by zero while supplying a fallback value finally remember that count column ignores null values whereas count counts every row these principles make set operations predictable conditional logic expressive and null heavy sql substantially easier to reason about https docs google com presentation d e 2pacx 1vsyt01y1aizh5l8l 0glwfi2y 7rzz1n g4 gklbrhf7ys shixvss4iphdhhj3gw pub start true loop true delayms 10000 please share share on linkedin opens in new window linkedin share on facebook opens in new window facebook share on x opens in new window x like loading author aviral gupta posted on august 9 2026 categories analytics tags analytics data sql leave a comment on sql set operations conditional logic union case null handling and advanced sql patterns posts pagination page 1 page 2 page 369 next page blog stats 1 366 937 hits bitcoin address bitcoin wallet 12fxl4og4mqtzt6prz1lkcmqq6ddgjk4yg latest book sas for r users books by ajay ohri python for r users r for business analytics r for cloud computing on fb on fb archives august 2026 19 july 2026 27 january 2026 1 july 2024 1 january 2024 1 august 2023 1 june 2023 8 april 2023 1 march 2022 1 august 2021 1 june 2021 1 march 2021 1 january 2021 1 december 2020 1 september 2020 1 july 2020 1 june 2020 1 may 2020 1 march 2020 1 february 2020 2 january 2020 8 december 2019 1 november 2019 2 october 2019 1 may 2019 2 march 2019 3 february 2019 1 january 2019 1 december 2018 3 october 2018 1 september 2018 7 august 2018 3 july 2018 6 june 2018 2 may 2018 1 april 2018 2 march 2018 7 february 2018 16 january 2018 4 december 2017 10 november 2017 8 october 2017 6 september 2017 4 august 2017 6 july 2017 6 june 2017 3 may 2017 4 march 2017 1 february 2017 2 january 2017 2 december 2016 3 november 2016 7 september 2016 7 august 2016 12 july 2016 12 june 2016 8 may 2016 11 april 2016 4 march 2016 22 february 2016 6 january 2016 4 december 2015 23 november 2015 19 october 2015 44 september 2015 16 august 2015 25 july 2015 12 june 2015 6 may ...