Ask Question Sign In Sign Up

Nice example how to use When and Case in SQL

Member

by adelia_boyer , in category: SQL , 9 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


Facebook Twitter LinkedIn Telegram Whatsapp Pocket

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
Store Procedure in SQL not good example
Switch statement in Javascript
How to round numbers and remove 0 in SQL