SQL查询关键字位置并截取；查询重复；

 select num_id,outer_id, substring(subtitle,charindex('9787',subtitle)  , 13) as ISBN  from tb_id_1_160613 where subtitle like '%9787%'

查询重复；

 select *
from dt_id_1_160626
where num_id in (select num_id from dt_id_1_160626 group by num_id having count(1) >= 2)