select top 1 * from T1 where Mid in(select Mid from T1 group by Mid)
select top 1 * from T1 where Mid in(select Mid from T1 group by Mid) 是錯誤的拉,隻有一條記錄, select MID,min(Mname) as Mname,min(Memo) as Memo from t1 group by mid 對的拉
不好意思,說錯了select MID,min(Mname) as Mname,min(Memo) as Memo from t1 group by mid 也不正確.不是以MID進行分組。
是錯誤的拉,隻有一條記錄,
select MID,min(Mname) as Mname,min(Memo) as Memo
from t1
group by mid
對的拉
from t1
group by mid
也不正確.不是以MID進行分組。