作者carlcarl (carl)
看板Database
标题Re: [SQL ] 同一资料表内之查询
时间Sat Oct 6 21:48:42 2012
※ 引述《hukhuk (ken)》之铭言：
: select a.* from product a
: inner join product b on a.manufactures=b.manufactures
: where a.company<>b.company
: group by a.company
: order by a.manufactures,a.company;
如果有个 7 乙 f n3
这个query会有问题
group by的後面应该多加个a.manufactures
然後order再改一下
变成
select a.* from product a
inner join product b on a.manufactures=b.manufactures
where a.company<>b.company
group by a.company, a.manufactures
order by a.manufactures,a.id;
--
http://blog.carlcarl.tw
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 111.242.43.148