大家帮忙看一条SQL语句,谢谢~~~
SELECT count(t.c) FROM
(SELECT Count(*) as c,V_PAGEVIEW.cid FROM V_PAGEVIEW GROUP BY V_PAGEVIEW.cid)
as t INNER JOIN V_PAGEVIEW ON t.cid = V_PAGEVIEW.cid where
entertime>'2007-1-19' and entertime<'2007-1-20' and t.c>1 and WGID='kiloboat@workgroup.ip4g.net'
大家帮忙看一下这条SQL有什么问题吗,一执行就后数据库就会一直在"正在执行查询"的状态下