Multiple Filtered SQL JOIN - Vertabelo Academy Online Interactive Course

PHOTO

Wed May 10 2023 00:41:20 GMT+0000 (Coordinated Universal Time)

Saved by @vnmshenoy

i had to look at the answer because there was a self join. i was close but missed out on excluding day (makes sense)

https://learnsql.com/track/sql-practice/course/joins/challenge/challenge-time/exercise-5

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 >>