为什么group by 后不是我希望的结果?
clkun 2005-06-20 09:54:13
有一表table1 字段: myno,status,
select a.status,a.myno,b.Total from table1 a inner join
(select myno,count(myno) as Total from table1 group by myno) b on a.myno= b.myno
为什么出来的结果 myno有重复? group by分组后再与表相连,应该只有myno是唯一的?
我主要想group by 也能列表其它字段显示出来,用group by myno,status 这样又不准
望指点!