sql查询语句——多重查询

显示全部楼层 · 2009-7-28 10:52:51

select system,count(ip) as cishufrom a where visit_time between '2009-01-05' and '2009-01-10' group by system

千问 · 2009-7-28 10:52:51

select system,count(id) 次数from awhere visit_time between '2009-01-05' and '2009-01-10'group by systemorder by count(id) desc;

千问 · 2009-7-28 10:52:51

select system,count(*) from a where visit_time between '2009-01-05' and '2009-01-10') group by system

千问 · 2009-7-28 10:52:51

select system,count(*) as 次数 from awhere visit_time betweet ‘2009-01-05’ and ‘2009-01-10’group by system;期待更好的答案

千问 · 2009-7-28 10:52:51

select system, count(*)as 次数 fromtablenamewhere visit_time between '2009-01-05' and '2009-01-10' group by systemselect system,count(*) as 次数 from a group by system where visit_time between '2009-01-05' and'2009-01-10'