[商管] 交大104資管計概

作者june89982014 (JJ)

看板Grad-ProbAsk

標題[商管] 交大104資管計概

時間Mon Jan 30 01:28:15 2017

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

推 liang0962054: GROUP BY A.SupervisorEmpID 01/30 16:01

→ liang0962054: HAVING COUNT(S.Supervisor EmpID)>5 01/30 16:02

→ liang0962054: 這樣寫可以嗎？ 01/30 16:02

→ liang0962054: 更正第一行是S.SupervisorEmpID 01/30 16:03

推 liang0962054: 欸不對一直打錯上面全都改成是E.SupervisorEmpID 01/30 16:06

→ liang0962054: 才對 01/30 16:06

→ sunflower304: SELECT S.name ,S.salary,count(*) 01/30 17:20

→ sunflower304: FROM Emp S , Emp E ,Dep D 01/30 17:20

→ sunflower304: WHERE S.Dnumber=D.Dnumber AND D.Dname='MIS' 01/30 17:21

→ sunflower304: AND S.EmpID=E.SupervisorEmpID 01/30 17:22

→ sunflower304: GROUP BY S.EmpID HAVING Count(*) 01/30 17:23

→ sunflower304: 我自己是這樣寫啦有錯歡迎糾正 01/30 17:23

→ sunflower304: 寫錯是HAVING　count(*)>5 01/30 17:24