本文介绍了如何通过SQL进行多表查询与统计分析，包括去重统计、条件筛选及联合查询等技巧。示例展示了如何从不同表中抽取数据并进行整合分析。
去重统计
->count('distinct visit_ip')多表查询
SELECT a.*,b.* FROM `visit` as a ,`visit_info` as b where a.visit_id=b.visit_id and (a.`visit_ip` LIKE '%手机%' or a.`visit_url` LIKE '%手机%' or b.`visit_client`=(select visit_client_id from visit_client where visit_client_name='手机') or b.`visit_os`=(select visit_os_id from visit_os where visit_os_name='手机') or b.`visit_browser`=(select visit_browser_id from visit_browser where visit_browser_name='手机') ) order by a.visit_id desc limit 0,10多表统计
select count(*) as total from `visit` as a ,`visit_info` as b where a.visit_id=b.visit_id and (a.`visit_ip` LIKE '%手机%' or a.`visit_url` LIKE '%手机%' or b.`visit_client`=(select visit_client_id from visit_client where visit_client_name='手机') or b.`visit_os`=(select visit_os_id from visit_os where visit_os_name='手机') or b.`visit_browser`=(select visit_browser_id from visit_browser where visit_browser_name='手机') )
扫一扫
219
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
