use of MOD(patient.id, 2) = 1 . if you need to find odd id's instead of say using in (1,3,5,7,....) use Mod
Wed Mar 22 2023 03:07:53 GMT+0000 (Coordinated Universal Time)
Saved by @vnmshenoy
https://learnsql.com/track/sql-practice/course/joins/non-equi/exercises/exercise-1
Comments