实现查询列不分组
select t.OrganizationCode,(t.OrganizationName) from DictOrganization t select t.OrganizationCode,max(t.OrganizationName)OrganizationName from DictOrganization t group by t.OrganizationCode
如下所示:
实现查询列不分组
select t.OrganizationCode,(t.OrganizationName) from DictOrganization t select t.OrganizationCode,max(t.OrganizationName)OrganizationName from DictOrganization t group by t.OrganizationCode
如下所示: