select a.keyword,a.type,b.pathname, max(a.material_id) as abc from mms_key_material as a inner join mms_material as b on a.material_id=b.id where a.type='2' group by a.keyword,a.type,b.pathname order by abc
上面查询出来 还是有重复列!!
我想消取a.material_id重复列 怎么写?
上面查询出来 还是有重复列!!
我想消取a.material_id重复列 怎么写?
1 2 4 a
1 1 1 2
1 1 1 3
select a.keyword,a.type,b.pathname, abs=(select max(a.material_id) from mms_key_material c where c.material_id=a.material_id and c.type='2 )
from mms_key_material as a inner join mms_material as b
on a.material_id=b.id
where a.type='2'
group by a.keyword,a.type,b.pathname --可试一下去掉效果
order by abc
from mms_key_material as a inner join mms_material as b
on a.material_id=b.id
where a.type='2'
group by a.keyword,a.type,b.pathname --可试一下去掉效果
order by abc
试试这个select a.keyword,a.type,b.pathname,
max(a.material_id) as abc
from mms_key_material as a inner join
(SELECT DISTINCT material_id FROM mms_material)b
on a.material_id=b.id
where a.type='2'
group by a.keyword,a.type,b.pathname
order by abc