【数据库】SQL语句解析

select 2 a.url 3 from websites a 4 inner join access_log b 5 on a.id=b.site_id 6 where b.count>200 只能取到不重复的网址的SQL语句：

1 select 
2  a.url 
3 from websites a 
4  where a.id in (select site_id from access_log b where b.count>200); 

 

 

【数据库】SQL语句解析

标签：inf   png   url   weight   htm   div   src   span   现在