020 数据库学习笔记--group by

实现查询列不分组

select t.OrganizationCode,(t.OrganizationName) from  DictOrganization t 
select t.OrganizationCode,max(t.OrganizationName)OrganizationName from  DictOrganization t group by t.OrganizationCode

如下所示：