PHP JavaScript C/C++ Golang Java Python SQL Ruby Kotlin Swift

Nice example how to use When and Case in SQL

Member

adelia_boyer

by adelia_boyer , in category: SQL , 2 months ago

Nice example how to use When and Case in SQL 🤣

1	SELECT a., ads., CASE ads.operation_id WHEN 1 THEN 2 WHEN 2 THEN 1 ELSE 3 END AS sort

no answers

Related Threads:

Nice way to generate SQL query in Python

Parse Command method in real project on the Java

Design Product Table in SQL when you don't know how is foreign keys works in SQL

Switch statement in Javascript

Store Procedure in SQL not good example

How to round numbers and remove 0 in SQL