SQL 查询语句
查询与信息系教师人数相同的其他系的系名
SELECT DISTINCT Tdept
FROM Teacher
WHERE Tdept<>'IS'
GROUP BY Tdept
HAVING COUNT(Tno) =(SELECT COUNT(Tno)
FROM Teacher
WHERE Tdept='IS');
SQL 查询语句
查询与信息系教师人数相同的其他系的系名
SELECT DISTINCT Tdept
FROM Teacher
WHERE Tdept<>'IS'
GROUP BY Tdept
HAVING COUNT(Tno) =(SELECT COUNT(Tno)
FROM Teacher
WHERE Tdept='IS');