100分求一个查询的写法。请大神看过来。谢谢！！！

[888888888888]

在表中快速查出状态没有 Released 的记录。
例如 1100580 就是状态中没有 Released 的

编号 状态
----------------
1100580 Planned
1100580 Reserved
1100580 Partially Delivered
1100580 Partially Delivered
1100580 Delivered
1100580 Delivered
1100580 Partially Delivered
1100580 Partially Delivered
1100581 Partially Delivered
1100581 Invoiced/Closed
1100581 Delivered
1100581 Invoiced/Closed
1100581 Picked
1100581 Reserved
1100581 Partially Delivered
1100581 Released

[大明湖畔_帅锅]

select *
from tb1
where replace(状态,'Released','') = 状态

[大明湖畔_帅锅]

select *
from tb1
where 状态 not like '%Released%'

[888888888888]

不对，效果没出来。 我就要一个结果 1100580

[sych888]

select * from tab_name where 编号 not in (select 编号 from tab_name where 状态='Released');

[yifeng0329]

select distinct 编号 from tab_name where 编号 not in (select 编号 from tab_name where 状态='Released');

[u010412956]

select * from t t1 where not exists(select 1 from t t2 where t1.编号=t2.编号 and t2.状态='Released')

[888888888888]

谢谢，问题解决了。