写了这么久SQL,你用过CASE表达式么?

CASE表达式CASE表达式不依赖于具体的数据库体术,可以提高代码的可移植性。简单表达式CASE sex WHEN '1' THEN '男' WHEN '2' THEN '女'ELSE '其他' END搜索表达式CASE WHEN sex = '1' THEN '男' WHEN sex = '2'
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×