case-when | BestHub

Python Programming Learning Circle

Jul 20, 2022 · Databases

10 Essential SQL Concepts for Interview Preparation

This article presents ten core SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—each explained with clear descriptions and practical query examples to help candidates ace data‑analysis interviews.

RankingSQLcase-when

0 likes · 11 min read

10 Essential SQL Concepts for Interview Preparation

Selected Java Interview Questions

Nov 1, 2020 · Databases

Using CASE WHEN, IF, and IFNULL Functions in MySQL for Conditional Logic

This article explains how MySQL's CASE WHEN, IF, and IFNULL functions can be used to implement conditional logic in SQL queries, providing syntax, examples, and combinations with aggregate functions for common data‑analysis scenarios.

DatabaseIFNULLMySQL

0 likes · 7 min read

Using CASE WHEN, IF, and IFNULL Functions in MySQL for Conditional Logic

Java Captain

Aug 7, 2019 · Databases

Practical Guide to Group, Join, and CASE WHEN Queries in SQL

This article provides a beginner‑friendly, step‑by‑step tutorial on common SQL operations—including GROUP BY aggregation, JOIN types, CASE WHEN expressions, and useful built‑in functions—illustrated with clear examples, typical pitfalls, and ready‑to‑use code snippets.

Database TutorialGROUP BYJoin

0 likes · 10 min read

Practical Guide to Group, Join, and CASE WHEN Queries in SQL