Giraffe Academy is rebranding! I’ve decided to re-focus the brand of this channel to highlight myself as a developer and teacher! The newly minted Mike Dane …
Original source
Nested Queries | SQL | Tutorial 18
Giraffe Academy is rebranding! I’ve decided to re-focus the brand of this channel to highlight myself as a developer and teacher! The newly minted Mike Dane …
Original source
10 responses to “Nested Queries | SQL | Tutorial 18”
i'm making an ecommerce website already made a db for it, but we are expanding so the nested model sounds like the best solution due to the filters and all that, but after watching this and making those huge queries (not difficult tho, just thinking about the whole mantainance and all the what would happen ifs), i feel like hierarchy model could be better, (can't work with mongodb since our hosting doesn't support it), what do you recommend me?
Can we also just use an inner join?
Select * from employee inner join works_with where total_sales > 30,000 ?
This was great, thank you!
Who on Earth gave him a dislike?!
Couldn’t figure out my problem.. watched this video.. then solved my problem in less than 2 mins. Thx dude!
Lol love The Office examples. Great informative video
SELECT employee.first_name, employee.last_name
FROM employee
WHERE employee.emp_id IN (
SELECT works_with.emp_id
FROM works_with
)
AND employee.branch_id = 2;
This brings up only Stanley Hudson while it should bring up 4 other people? Could you please explain this
great job! Contributed!
hello, i have a question: the first exercise is trying to get employees whose total sales are for a SINGLE CLIENT, right? what if i wanted to list their total sales for all clients? Please help! :/ ps. very useful videos
Very Well Explained Sir ♥️♥️ Thank You