过滤条件(Filter where on condition)

 我有这张桌子 
 
User        | SecretId | Status
warheat1990 |     NULL |    REV
warheat1990 |     NULL |    COM
warheat1990 |        1 |    REV
warheat1990 |        1 |    COM
 
 我想过滤掉数据（Status = REV和SecretId IS NOT NULL合并），所以最终结果将是 
 
User        | SecretId | Status
warheat1990 |     NULL |    REV
warheat1990 |     NULL |    COM
warheat1990 |        1 |    COM
 
 我的查询 
 
SELECT * FROM TABLE WHERE User = 'warheat1990' AND (Status <> 'REV' AND SecretId IS NULL)
 
 但它不起作用，因为它只给我这条行。 
 
User        | SecretId | Status
warheat1990 |     NULL |    COM
 
 那么如何使用Status = REV排除数据，但仅当SecretId不为NULL时才排除数据 
 
 我觉得愚蠢，我无法弄清楚这个简单的案例。 任何帮助将不胜感激。 

I have this table
 
User        | SecretId | Status
warheat1990 |     NULL |    REV
warheat1990 |     NULL |    COM
warheat1990 |        1 |    REV
warheat1990 |        1 |    COM
 
I want to filter out data with (Status = REV and SecretId IS NOT NULL combined) so the final result will be
 
User        | SecretId | Status
warheat1990 |     NULL |    REV
warheat1990 |     NULL |    COM
warheat1990 |        1 |    COM
 
My query
 
SELECT * FROM TABLE WHERE User = 'warheat1990' AND (Status <> 'REV' AND SecretId IS NULL)
 
but it's not working because it gives me only this ROW.
 
User        | SecretId | Status
warheat1990 |     NULL |    COM
 
So how do I exclude data with Status = REV but only if SecretId IS NOT NULL
 
I feel stupid that I can't figure out this simple case. Any help will be appreciated.

原文：https://stackoverflow.com/questions/36637954