请大家帮忙看看这个SQL语句

[happying2000]

现在有这样的一个数据表(SP)
供应商号(Sno) 零件号(Pno) 零件数量(Qty)

查询至少包含了供应商号"168"所供应的全部零件的Sno
请大家帮忙看看这个SQL语句怎么填写完整?谢谢

select Sno
from SP SPX
where ___
(select * from SP spy where ____and not exists
(select * from SP spz where ____));

[wzy_love_sly]

select * from 
(select * from SP where (select count(*) from SP group by id having Sno='168')>=1)

a where 条件

最少要包含Sno等于168的数据，理解对吗？

[hjj841020]

select * from sp where charindex('168',sno)>0

[happying2000]

理解是对的
我的意思是这样讲我给出的这个SQL 补充完整呢？

[dawugui]

select * from sp where charindex( '168',sno) >0
--
select * from sp where sno like '%168%'
select * from sp where sno like '168%'
select * from sp where sno like '%168'

[happying2000]

select Sno
from SP SPX
where ___
(select * from SP spy where ____and not exists
(select * from SP spz where ____));

就是把这个SQL补充完整哈，谢谢

[happying2000]

没人知道吗？？

[happying2000]

就是nokia4321
的意思哈

[nokia4321]

select Sno
from SP SPX
where ___
(select * from SP spy where ____and not exists
(select * from SP spz where ____));
楼主意思就用这个格式？

[cs_oldhorse]

学习

[ojuju10]

select * from tb where sno=168
union
select * from tb
order by newid()