select * from [CustomerRegister] a WHERE EnterprisRegisterID<'500' and not exists(select 1 from [CustomerRegister] where EnterprisRegisterID=a.EnterprisRegisterID and id>a.id)
select * from [CustomerRegister] a WHERE EnterprisRegisterID<'500' and not exists(select 1 from [CustomerRegister] where EnterprisRegisterID=a.EnterprisRegisterID and ID>a.ID)
WHERE EnterprisRegisterID<'500'
and not exists(select 1 from [CustomerRegister] where EnterprisRegisterID=a.EnterprisRegisterID and id>a.id)
select * from [CustomerRegister] a
WHERE EnterprisRegisterID<'500' and not exists(select 1 from [CustomerRegister] where EnterprisRegisterID=a.EnterprisRegisterID and ID>a.ID)
不过楼主的图挂了
哪位版主给他编辑一下