這是我找到的答案
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
請問這樣出來的結果會一樣嗎 謝謝
--
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
請問這樣出來的結果會一樣嗎 謝謝
--
All Comments