98年高考資料庫第二題第三小題 - 高考
By Kristin
at 2014-04-13T17:59
at 2014-04-13T17:59
Table of Contents
這是我找到的答案
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
請問這樣出來的結果會一樣嗎 謝謝
--
Tags:
高考
All Comments
By Zanna
at 2014-04-17T20:51
at 2014-04-17T20:51
By Tracy
at 2014-04-22T20:29
at 2014-04-22T20:29
By Barb Cronin
at 2014-04-25T09:39
at 2014-04-25T09:39
By Tristan Cohan
at 2014-04-28T14:05
at 2014-04-28T14:05
By Charlotte
at 2014-05-01T13:02
at 2014-05-01T13:02
By Adele
at 2014-05-02T15:32
at 2014-05-02T15:32
By Kyle
at 2014-05-07T05:22
at 2014-05-07T05:22
By Rosalind
at 2014-05-07T18:42
at 2014-05-07T18:42
By Linda
at 2014-05-12T14:50
at 2014-05-12T14:50
By Hedwig
at 2014-05-14T02:43
at 2014-05-14T02:43
By Daniel
at 2014-05-18T15:31
at 2014-05-18T15:31
Related Posts
高考資料庫
By Blanche
at 2014-04-13T01:10
at 2014-04-13T01:10
[新聞] 募兵盼放寬轉任公職 試委質疑
By Hedy
at 2014-04-12T23:46
at 2014-04-12T23:46
行政處分附款
By Puput
at 2014-04-12T17:01
at 2014-04-12T17:01
遊行可以準備國考嗎
By Lydia
at 2014-04-11T22:49
at 2014-04-11T22:49
102地特四等上榜心得
By Charlie
at 2014-04-10T16:27
at 2014-04-10T16:27