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

PHOTO

Wed Mar 22 2023 03:07:53 GMT+0000 (Coordinated Universal Time)

Saved by @vnmshenoy

SELECT tr.name,pat.first_name,pat.last_name
from therapy th
join treatment tr on th.treatment_type=tr.type
join patient pat on th.patient_id=pat.id
join physician ph on th.physician_id=ph.id
where ph.last_name in ('Core','Calderwood')
and mod(pat.id,2)=1

https://learnsql.com/track/sql-practice/course/joins/non-equi/exercises/exercise-1

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

SQL

@vnmshenoy

SQL Basics - SQL online course | LearnSQL.com SQL Basics - SQL online course | LearnSQL.com SQL Basics - SQL online course | LearnSQL.com select year from date interesting having clause eg order by the summed value groupby full query SQLLearn All/Any operator-really interesting SQL Basics - SQL online course | LearnSQL.com Find Out How To Use Filtering In SQL JOINs - Vertabelo Academy Online Interactive Course Improve Your Knowledge By Learning SQL Multiple JOINs - Vertabelo Academy Online Interactive Course Learn How To Use SQL JOINs To Self JOIN Tables - Vertabelo Academy Online Interactive Course Improve Your Skills By Learning Non-Equi Self JOIN - Vertabelo Academy Online Interactive Course Learn How To Use Non-Equi SQL JOINs -We also don't have to use the equality operator when joining tables. We are free to use other comparison operators (<, >, <=, >=, !=, <>) or the BETWEEN operator: 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 what i liked about this is that the answer provided had used "AND" between joins as well Multiple Filtered SQL JOIN - Vertabelo Academy Online Interactive Course Multiple Non-Equi JOINs Practice - self join table pe join on non-equi join and not primary key concatenation operator || (doesnt work on all DBs) Inbuilt SQL functions

Browse more snippets >>