Tag

case

1 views collected around this technical thread.

Full-Stack Internet Architecture
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.

DatabaseQuery OptimizationSQL
0 likes · 8 min read
Using SQL CASE Expressions for Data Aggregation and Conditional Updates
php中文网 Courses
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