计数和条件大于2的SELECT子句

Question

例如。有这两张表

//DEPARTMENT
DNAME
----------
RESEARCH
   IT
 SCIENCE

DEPTROC表格

//DEPTLOC
DNAME        CITY       STREET
--------------------------------
RESEARCH    BOSTON        41
   IT       LONDON        22
RESEARCH    NEWYORK       33
 SCIENCE    ENGLAND       22

所以当我运行这个语句时

SELECT DNAME FROM DEPARTMENT d 
    WHERE (SELECT count(CITY,STREET) from DEPTLOC having by > 2
//using having by

我应该写些什么才能得到这样的结果如果位置超过1意味着2或以上，则显示DNAME一个位置是平均城市+街道

//OUTPUT
DNAME
-----------
RESEARCH     <-- displayed because got 2 location , more than 1

Answer 1

这能满足您的要求吗？

SELECT dl.DNAME
FROM DEPTLOC dl
GROUP BY dl.DNAME
HAVING COUNT(*) > 1;