Create a MySQL query for all students in the Computer Science DepartmentTable departments columns = DepartmentId DepartmentNameTable students columns = DepartmentId StudentId StudentName

SELECT StudentId, StudentName FROM students WHERE DepartmentId = (SELECT DepartmentId FROM departments WHERE DepartmentName = 'Computer Science')

原文地址: https://www.cveoy.top/t/topic/fp9f 著作权归作者所有。请勿转载和采集!