iteye_16559的博客

select b.name, sum(c.count) from websites b inner join access_log c on b.id = c.site_id group by c.site_id having sum(c.count) > 500

[code="java"]SELECT A FROM (SELECT A,B FROM TABLE) T where A='XXXX';[/code] [code="java"]select name, count from (select b.name name, sum(c.count) count from websites b inner join access_log c o...