作者hukhuk (ken)
看板Database
标题Re: [SQL ] sql 子查询 过久无反应
时间Fri Mar 23 13:20:47 2012
select table.ID,date,count(*)
from table
inner join \
(select ID from table where func_date between '19960101' AND '19991231') as b
on table.ID=b.ID
where date BETWEEN '20000101' AND '20031231'
group by ID,date
改成这样不知行不行...XD
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 111.249.147.163
1F：推 slalala:我猜这样会好多 刚刚那种SUB QEURY结果会"刺激" 03/24 10:19
2F：推 s9234140:不行ㄟ 还是过久 03/28 10:54