Re: [SQL ] sql 子查詢 過久無反應
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
推
03/24 10:19, , 1F
03/24 10:19, 1F
推
03/28 10:54, , 2F
03/28 10:54, 2F
討論串 (同標題文章)