group by的SQL语句

distinct a. [ ProjectID ] , a. [ ProjectName ] from projecttable as a

得出的结果为

其实想要的数据，只是不同的ProjectID所对应的ProjectName

 

 

修改sql语句为

 select  
 distinct   
a.  [  ProjectID  ]  ,
a.  [  ProjectName  ]  
 from   
projecttable   as   a
  group   by  a. [  ProjectID  ] 

 

group by的SQL语句

标签：

查看更多关于group by的SQL语句的详细内容...