kevinye 发表于 2013-2-4 22:29:36

SQL问题

select distinct g.*
from groups g inner join topics t on (t.group_id = g.id)
order by t.created_at desc
limit 0,6

为什么结果不对?
相对于

select   g.*
from groups g inner join topics t on (t.group_id = g.id)
order by t.created_at desc
limit 0,6明显不一致
页: [1]
查看完整版本: SQL问题