取条数
来源：互联网 发布：python update mysql 编辑：程序博客网 时间：2024/06/14 23:17
SELECT count([tel])
,[smscontent]
FROM [Address].[dbo].[T_addr]
where smscontent like '%地址：深圳市宝安区44区顺丰路物业大楼东座5楼%'
,[smscontent]
FROM [Address].[dbo].[T_addr]
where smscontent like '%地址：深圳市宝安区44区顺丰路物业大楼东座5楼%'
group by [smscontent]
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [src]
,[tel]
,[smscontent]
FROM [Address].[dbo].[dizhi_source]
where smscontent like '%地址：深圳市宝安区44区顺丰路物业大楼东座5楼%'
0 0
