27,580
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([a] int,[b] nvarchar(26))
Insert #T
select 1,N'1001' union all
select 2,N'F1001' union all
select 3,N'F1001' union all
select 4,N'21003' union all
select 5,N'70010' union all
select 6,N'F70010'
Go
--测试数据结束
SELECT *
FROM #T a
WHERE NOT EXISTS
(
SELECT * FROM #T b WHERE 'F' + a.b = b.b
);