where 子句来自 where 子句 [英] where clause from where clause

问题描述

我需要这样做:

有一个名为 table1 的表，它有一个员工 ID 列、只有值 1 和 0 的状态列以及值为 100,101,102 的部门列.

There is a table called table1 it has a employee id column,status column which has values 1 and 0 only and a department column with values 100,101,102.

我想列出所有状态 = 0 和(部门 = 100，其状态 = 1)的员工 ID

i want to list all employeeid with the status = 0 and (department=100 whose status=1)

请帮帮我

推荐答案

Where Status = 0 or (Department = 100 And Status = 1)

这篇关于where 子句来自 where 子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！