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