如何在SQL中检查多个不相关的条件？

萨米特·波德尔

我有以下查询：

SQL> SELECT DISTINCT INSTRUCTORADDRESSMODPER.instructor_id, Instructor.instructor_name, InstructorRank.salary, Student.specification_id
  2  FROM INSTRUCTORADDRESSMODPER
  3  JOIN Student ON INSTRUCTORADDRESSMODPER.student_id = Student.student_id
  4  JOIN Instructor ON INSTRUCTORADDRESSMODPER.instructor_id = Instructor.instructor_id
  5  JOIN InstructorRank ON Instructor.instructor_rank = InstructorRank.instructor_rank
  6  ORDER BY specification_id;

结果如下：

我试图获得的结果显示与图中突出显示的相同薪水和相同规格的讲师具有相同的列值。现在，这两个条件需要完全不同的检查，我什至不知道如何开始。

MDO

您需要这样的东西吗？

SELECT instructor_id, instructor_name, instructor_name, specification_id
FROM (
SELECT DISTINCT INSTRUCTORADDRESSMODPER.instructor_id, Instructor.instructor_name, InstructorRank.instructor_name, Student.specification_id
, COUNT(distinct INSTRUCTORADDRESSMODPER.instructor_id)over(partition by InstructorRank.salary, Student.specification_id) cnt
  FROM INSTRUCTORADDRESSMODPER
  JOIN Student ON INSTRUCTORADDRESSMODPER.student_id = Student.student_id
  JOIN Instructor ON INSTRUCTORADDRESSMODPER.instructor_id = Instructor.instructor_id
  JOIN InstructorRank ON Instructor.instructor_rank = InstructorRank.instructor_rank
  ORDER BY specification_id
  )
WHERE cnt > 1
;

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。