针对distinct后只能显示一列的弊端
故有以下方法查找回全部列数据
select * from [XmainDB].[dbo].[HWConfig_Table] where Number in (select min(Number) from [XmainDB].[dbo].[HWConfig_Table] group by CardNo)
针对distinct后只能显示一列的弊端
故有以下方法查找回全部列数据
select * from [XmainDB].[dbo].[HWConfig_Table] where Number in (select min(Number) from [XmainDB].[dbo].[HWConfig_Table] group by CardNo)