Question: Would the following two queries ever return different results? ( disregard ordering ) select PAT _ ID from PATIENT where PATIENT.PAT _ ID in (

Would the following two queries ever return different results? (disregard ordering)
select PAT_ID
from PATIENT
where
PATIENT.PAT_ID in (select PATIENT_ID from MY_CUSTOM_TABLE)
Select PAT_ID
from PATIENT
where
exists (select null from MY_CUSTOM_TABLE where MY_CUSTOM_TABLE.PATIENT_ID = PATIENT.PAT_ID)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!