Pilih query yang tepat untuk menampilkan doctor appointment terbaru

Question

Answer

SELECT doctor_id, patient_id, time  
 FROM DOCTOR_APPOINTMENT  
 WHERE time <= ANY (SELECT time FROM DOCTOR_APPOINTMENT);

Answer

SELECT doctor_id, patient_id, time  
 FROM DOCTOR_APPOINTMENT  
 WHERE time <= ALL (SELECT time FROM DOCTOR_APPOINTMENT);

Answer

SELECT doctor_id, patient_id, time  
 FROM DOCTOR_APPOINTMENT  
 WHERE time >= ALL (SELECT time FROM DOCTOR_APPOINTMENT);

Answer

SELECT doctor_id, patient_id, time  
 FROM DOCTOR_APPOINTMENT  
 WHERE time >= ANY (SELECT time FROM DOCTOR_APPOINTMENT);

Crowdly