用 case when 写一个733：过滤条件： pause_day = 1，channel = 2 734 : 过滤条件： pause_day = 7，channel = 2 735 : 过滤条件： pause_day = 1，channel = 1 736 : 过滤条件： pause_day = 7，channel = 1 798 : 过滤条件： pause_day = 1，channel = 3 799 : 过滤条件： pause_day = 7，channel = 3的查询语句

733:

SELECT *
FROM table_name
WHERE
    CASE WHEN pause_day = 1 AND channel = 2 THEN 1 ELSE 0 END = 1;

734:

SELECT *
FROM table_name
WHERE
    CASE WHEN pause_day = 7 AND channel = 2 THEN 1 ELSE 0 END = 1;

735:

SELECT *
FROM table_name
WHERE
    CASE WHEN pause_day = 1 AND channel = 1 THEN 1 ELSE 0 END = 1;

736:

SELECT *
FROM table_name
WHERE
    CASE WHEN pause_day = 7 AND channel = 1 THEN 1 ELSE 0 END = 1;

798:

SELECT *
FROM table_name
WHERE
    CASE WHEN pause_day = 1 AND channel = 3 THEN 1 ELSE 0 END = 1;

799:

SELECT *
FROM table_name
WHERE
    CASE WHEN pause_day = 7 AND channel = 3 THEN 1 ELSE 0 END = 1;

相关问题

用case when 的方法写一下 pause_day = 1，channel = 2、 pause_day = 7，channel = 2 、 pause_day = 1，channel = 1、 pause_day = 7，channel = 1 、 pause_day = 1，channel = 3 、pause_day = 7，channel = 3

以下是使用 case when 的SQL语句：

SELECT 
    CASE 
        WHEN pause_day = 1 AND channel = 2 THEN '条件1'
        WHEN pause_day = 7 AND channel = 2 THEN '条件2'
        WHEN pause_day = 1 AND channel = 1 THEN '条件3'
        WHEN pause_day = 7 AND channel = 1 THEN '条件4'
        WHEN pause_day = 1 AND channel = 3 THEN '条件5'
        WHEN pause_day = 7 AND channel = 3 THEN '条件6'
        ELSE '其他情况'
    END AS result
FROM 
    your_table;

其中，'条件1'表示满足条件 pause_day = 1，channel = 2；'条件2'表示满足条件 pause_day = 7，channel = 2；以此类推。如果不满足以上任何一种条件，则返回 '其他情况'。

SELECT CASE WHEN pause_day = 1 AND channel = 2 THEN '条件1' WHEN pause_day = 7 AND channel = 2 THEN '条件2' WHEN pause_day = 1 AND channel = 1 THEN '条件3' WHEN pause_day = 7 AND channel = 1 THEN '条件4' WHEN pause_day = 1 AND channel = 3 THEN '条件5' WHEN pause_day = 7 AND channel = 3 THEN '条件6' ELSE '其他情况' END AS result FROM your_table; 中条件应该怎么写

在上述 SQL 中，条件是根据 `pause_day` 和 `channel` 的值而分别判断的。如果你想要知道每个条件具体对应的含义，可以参照以下内容：

- 条件1：`pause_day` 等于 1 并且 `channel` 等于 2。
- 条件2：`pause_day` 等于 7 并且 `channel` 等于 2。
- 条件3：`pause_day` 等于 1 并且 `channel` 等于 1。
- 条件4：`pause_day` 等于 7 并且 `channel` 等于 1。
- 条件5：`pause_day` 等于 1 并且 `channel` 等于 3。
- 条件6：`pause_day` 等于 7 并且 `channel` 等于 3。

如果你想要根据不同的条件输出不同的结果，可以使用 `CASE WHEN` 语句，例如：

SELECT 
    CASE
        WHEN pause_day = 1 AND channel = 2 THEN '条件1'
        WHEN pause_day = 7 AND channel = 2 THEN '条件2'
        WHEN pause_day = 1 AND channel = 1 THEN '条件3'
        WHEN pause_day = 7 AND channel = 1 THEN '条件4'
        WHEN pause_day = 1 AND channel = 3 THEN '条件5'
        WHEN pause_day = 7 AND channel = 3 THEN '条件6'
        ELSE '其他情况'
    END AS result 
FROM 
    your_table;

这样，查询的结果就会根据不同的条件输出不同的结果。