摘要:
该校区下所有员工select * from employee eINNER JOIN employee_department ed on e.id =ed.EmployeeIdLEFT JOIN department d on d.Id= ed.DepartmentIdwhere e.IsDelet 阅读全文
摘要:
有一张成绩表,不同学生考试的课程可能是不同的,求一句SQL找出每门课大于90分的学生 表名 :t列名:姓名,课程名称,分数 SQL1:select name from test.stugroup by namehaving count(score) =sum(case when score>90 t 阅读全文