Tag

case

0 views collected around this technical thread.

Full-Stack Internet Architecture

Dec 12, 2020 · Databases

Using SQL CASE Expressions for Data Aggregation and Conditional Updates

This article explains the two forms of SQL CASE expressions, demonstrates how to use CASE for concise data aggregation and conditional updates, and provides practical examples with customer and order tables to simplify queries and avoid pitfalls.

Query OptimizationSQLcase

0 likes · 8 min read

Using SQL CASE Expressions for Data Aggregation and Conditional Updates

php中文网 Courses

Nov 10, 2020 · Backend Development

Shell Script Conditional Structures: Using if and case Statements

This article introduces shell script conditional structures, explains the syntax of if (single, double, and multi-branch) and case statements, and provides step‑by‑step examples including a grading script and a start/stop/restart command script with full Bash code.

bashcaseconditional

0 likes · 5 min read

Shell Script Conditional Structures: Using if and case Statements