求一条SQL语句，着急！在线等

显示全部楼层 · 2011-12-26 16:44:34

使用distinct 关键字如：select distinct 单位Id，周期Id from 表A...

千问 · 2011-12-26 16:44:34

select distinct 单位Id,周期Idfrom a--distinct就可以搞定了...

千问 · 2011-12-26 16:44:34

DECLARE del_cur CURSOR FOR SELECT del.货号,isnull(del.数量,0),isnull(del.单价,0),isnull(del.门店,0)FROMdeleted del OPEN del_curFETCH NEXT FROM del_cur INTO @del_hh,@del_num,@del_Pr...

千问 · 2011-12-26 16:44:34

select max(单位ID),max(周期ID) from A group by 单位ID ,周期ID...

千问 · 2011-12-26 16:44:34

select 单位Id, 周期Id from 表名 group by 单位Id, 周期Id...