[商管] 交大104資管計概

看板Grad-ProbAsk作者 (JJ)時間9年前 (2017/01/30 01:28), 編輯推噓2(2推 0噓 11→)
留言13則, 2人參與, 最新討論串1/1
http://i.imgur.com/lodudvy.jpg
目前是這樣寫 SELECT E.EMPNAME, E.SALARY FROM EMPLOYEE E, DEPARTMENT D WHERE D.DNAME='MIS' AND COUNT(E.EmpID=E.SupervisorEmpID)>5 要找至少有五個employees的supervisor這部分我覺得寫錯了 但又不知道怎麼改 麻煩大家指教~謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.41.135.221 ※ 文章網址: https://www.ptt.cc/bbs/Grad-ProbAsk/M.1485710901.A.A02.html
推
01/30 16:01, , 1F
GROUP BY A.SupervisorEmpID
01/30 16:01, 1F
→
01/30 16:02, , 2F
HAVING COUNT(S.Supervisor EmpID)>5
01/30 16:02, 2F
→
01/30 16:02, , 3F
這樣寫可以嗎？
01/30 16:02, 3F
→
01/30 16:03, , 4F
更正 第一行是S.SupervisorEmpID
01/30 16:03, 4F
推
01/30 16:06, , 5F
欸不對 一直打錯 上面全都改成是E.SupervisorEmpID
01/30 16:06, 5F
→
01/30 16:06, , 6F
才對
01/30 16:06, 6F
→
01/30 17:20, , 7F
SELECT S.name ,S.salary,count(*)
01/30 17:20, 7F
→
01/30 17:20, , 8F
FROM Emp S , Emp E ,Dep D
01/30 17:20, 8F
→
01/30 17:21, , 9F
WHERE S.Dnumber=D.Dnumber AND D.Dname='MIS'
01/30 17:21, 9F
→
01/30 17:22, , 10F
AND S.EmpID=E.SupervisorEmpID
01/30 17:22, 10F
→
01/30 17:23, , 11F
GROUP BY S.EmpID HAVING Count(*)
01/30 17:23, 11F
→
01/30 17:23, , 12F
我自己是這樣寫啦 有錯歡迎糾正
01/30 17:23, 12F
→
01/30 17:24, , 13F
寫錯 是HAVING　count(*)>5
01/30 17:24, 13F
‣ 更多 june89982014 的文章
文章代碼(AID): #1OZYOre2 (Grad-ProbAsk)