sql语句where后面判断

Question

请问如何在SQLserver中在where使用分支if或者case进行筛选条件的分支查询？

Answer 1

关于这部分翻阅我们官方技术文档，对于TSQL语句编写我们已经整理非常详细的PDF了

#first：
SELECT *
FROM table_name
WHERE column_name = CASE
                        WHEN condition1 THEN value1
                        WHEN condition2 THEN value2
                        ...
                        ELSE default_value
                    END;
#second：
IF condition1
    SELECT *
    FROM table_name
    WHERE column_name = value1;
ELSEIF condition2
    SELECT *
    FROM table_name
    WHERE column_name = value2;
...
ELSE
    SELECT *
    FROM table_name
    WHERE column_name = default_value;
END IF;