Think the rebranding is a good idea. You really are a good teacher and the fact that you teach so many languages is really useful. It makes this my go-to channel for learning new stuff. The name "Giraffe Academy" indicated there might be another teacher in another language, in which case I would not go to this channel by default.
I got a question, in the video where you put in the query SELECT salary FROM employee UNION SELECT total_sales FROM works_with; only 17 records show up, the second 55,000 does not show up. Why is that? I added emp_id to both select statements and it showed the proper 18. Thank you and awesome video series!
I can't thank you enough for these tutorials. You are an amazing teacher.
Think the rebranding is a good idea. You really are a good teacher and the fact that you teach so many languages is really useful. It makes this my go-to channel for learning new stuff. The name "Giraffe Academy" indicated there might be another teacher in another language, in which case I would not go to this channel by default.
Thanks for such nice tutorial. Is this possible to run update query after select query? Using union or any other trick.
Love how all the examples are from the series The office makes it more interesting for me to learn
I just observed, thx for highlighting it
I was laughing so hard when I saw it xD
Notice that Jan is not Levinson Gould *Michael's face reaction to the camera* ;)
Awesome teaching!
Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.
Very understandable explanations, thanks for this video
I got a question, in the video where you put in the query
SELECT salary
FROM employee
UNION
SELECT total_sales
FROM works_with;
only 17 records show up, the second 55,000 does not show up. Why is that? I added emp_id to both select statements and it showed the proper 18. Thank you and awesome video series!
UNION will result in distinct values even tho you didn't mention the keyword DISTINCT.
To get duplicates, u need to use UNION ALL
Amazing teacher! many thanks
What if we wanted a column where it tells us if the money is coming in or going out? How would we make a custom column for unions like that?
is it possible to query to union. What I mean is after using union on multiple table is it possible to the pull out specific data from that union
good explanation. thanks
This was very helpful, thank you so much!
i wanna get in touch with you, how do i sir ?
so touching for an excellent video
hahahaha these are the office characters.
nice
「目標を指定してお金が必要」、
where can I get the soure code ?
Thanks!! This was very helpful
thank you i'm using sqlServer and i find this really usefull
Thank you for teaching! сиз берген такириптер оте унап тур!
ty
thanks sir
Amazing.
Superb 🎉❤
thanks for your simplicity
Thank you this is super helpful
thank you for these!!
Fabulous!
God bless you!
You are the best!
So good tutorial
great tutorial!
Tutorial on R language please.
Are you doing ML?