推 slalala:我猜這樣會好多 剛剛那種SUB QEURY結果會"刺激" 03/24 10:19
推 s9234140:不行ㄟ 還是過久 03/28 10:54
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