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

a where 条件

------解决方案--------------------
select * from sp where charindex('168',sno)>0

------解决方案--------------------
SQL code
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'

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