[問題] 98年高考資料庫第二題第三小題
這是我找到的答案
SELECT pId, COUNT(*)
FROM BorrowRecord
WHERE borrowDate between ‘2009/01/01’ AND ‘2009/12/31’AND
pId in (
SELECT pId
FROM BorrowRecord
GROUP pId
HAVING COUNT(*)>=10
)
我自己寫的是
select pid,count(*)
from BorrowRecord
where borrowDate between ‘2009/01/01’ AND ‘2009/12/31’
group by pid
having count(*)>10
請問這樣出來的結果會一樣嗎 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.109.6.129
※ 文章網址: http://www.ptt.cc/bbs/Examination/M.1397383191.A.558.html
推
04/13 19:15, , 1F
04/13 19:15, 1F
推
04/13 19:34, , 2F
04/13 19:34, 2F
謝謝!
※ 編輯: Burgerking24 (140.109.6.129), 04/13/2014 20:21:46
推
04/18 23:05, , 3F
04/18 23:05, 3F
推
04/18 23:09, , 4F
04/18 23:09, 4F
→
04/18 23:09, , 5F
04/18 23:09, 5F
→
04/18 23:09, , 6F
04/18 23:09, 6F
→
05/21 14:42, , 7F
05/21 14:42, 7F
→
03/24 02:03, , 8F
03/24 02:03, 8F
→
03/24 02:05, , 9F
03/24 02:05, 9F
→
03/24 02:06, , 10F
03/24 02:06, 10F
→
03/24 02:07, , 11F
03/24 02:07, 11F
→
03/24 02:07, , 12F
03/24 02:07, 12F
→
03/24 02:09, , 13F
03/24 02:09, 13F
→
03/24 02:10, , 14F
03/24 02:10, 14F