Thank you very much for the second part. Most of the videos on joins doesn't include the second portion of this video where you utilize the "where" clause. Earned yourself a subscriber.
That last bit of the video was helpful to really understand the Joins since I use the 'less preferred one but more commonly used' lol didnt event realize it
I am having trouble finding help on how to do Insert Into Select w/ join feature . I have data in table 1, which describes a motorsports racing session. I have table 2 which has information about each of the riders including their bike number, team , manufacturer, name, etc. - both tables have a column Rider ID, where the Riders table (table 2) has Rider ID as the primary key, and on the Table 1 , Rider ID is the foreign key. I want to write a insert into select join statement that merges in the individual rider data such as bike number, team, manufacturer , and name - into Table 1 . Can you help me please?
Suppose you are given a relation grade points(grade, points), which provides a conversion from letter grades in the takes relation to numeric scores; for example, an “A” grade could be specified to correspond to 4 points, an “A−” to 3.7 points, a “B+” to 3.3 points, a “B” to 3 points, and so on. The grade points earned by a student for a course offering (section) is defined as the number of credits for the course multiplied by the numeric points for the grade that the student received. Given the above relation, and our university schema, write each of the following queries in SQL. You can assume for simplicity that no takes tuple has the null value for grade. a. Find the total grade-points earned by the student with ID 12345, across all courses taken by the student. b. Find the grade-point average (GPA) for the above student, that is, the total gradepoints divided by the total credits for the associated courses. c. Find the ID and the grade-point average of every student. LODI PA TUTORIAL NGA NITO PARA MAY GUIDE ME SA SUNOD NA ACTIVITY SALAMAT
You can actually notice that the amount of results when using an Inner Join is 12, and then after you removed it to use WHERE, it is 13. I was wondering what are you missing out on?
Nice Tutorial, especially when I watch it in 1.5X speed. Also, This JON example you did, is it an INNER JOIN or OUTTER JOIN? How do you distinguish these two JOINs in code?
Hey Madhur, i see that we got 12 results when we used the Join query, but we got 13 results when we used Where clause, can you explain this briefly ? is it not recommended to use where clause for this kind of queries ?
what would the query be if I wanted ALL the columns from both the tables? Do I still have to type out each column? Is there a shorter way? like Select * from both tables and join them somehow?
Hi Madhur, I am trying to create a table in sql workbench where i want create a column where i want to insert ip address but not sure which data type should i select, so could you help me with the correct data type for ip address.
If anyone here can help I tried following exact the same steps to execute the join command but it didn't work ? Is that because he populated the id column in the tutorial_info table from the old tutorial or what ?? and if we have to fetch the id column from the old tutorial, what is the syntax for inserting the remaining values (views, likes, dislikes, shares) without writing the id value ? how can we skip that?
What kind of sql is this? I'm using oracle and it's giving me error "from tutorials as t" (@6:06) where t is underlined in red, saying SQL command not properly ended. What gives?
(table).(column) = SELECT users.username, users.profiledescription,stats.postcount FROM users,stats; With Insert you do the same. INSERT INTO users,stats (users.username,users.profiledescription,stats.postcount) VALUES ('$username','$description','postcount'); You could also do: INSERT INTO users,stats (username,profiledescription,postcount) VALUES ('$username','$description','postcount'); You need to keep in mind that you can not have 2 same colum names in two tables, if you have 2 same column names you need to specify the table. 'table.username' or 'stats.username'. If you have only a "profiledescription" column inside the "users" table but NOT inside "stats" you do NOT need to type 'users.profiledescription'. @Edit, before people start crying and leaving shit comments on me, i know that Sai's comment is 1year+ old, this video is from 2014 and i still came hear and learned something. When someone watches this tutorial... he might also ask about the "Insert query"... so here is the answer (above).
I am using Oracle DB and while aliasing a table name i am unable to use AS. I had to use table alias like this " tutorial t". Is this because of Oracle dialect?
Alright, for those poor bastards out there trying to learning Kusto Query Language where tutorials do not exist, the translation would be: | join OTHER_TABLE on $right._COLUMN_NAME == $left._COLUMN_NAME This will merge the two tables where the column name is matches.
Watching in 2024😢
Great tutorial. I was pretty intimidated by JOINS but you made it nice and simple. Thanks man
Thank you very much for the second part. Most of the videos on joins doesn't include the second portion of this video where you utilize the "where" clause. Earned yourself a subscriber.
Very simple and to the point explanation of how JOINS work in SQL.
One of the simplest and yet ery helpful tutorial Ive found! thanks man! keep this up :)
This is all I needed looked for hours and hours and couldn't find anything solid.
Great work man thanks👍🏻👍🏻
Thanks Sarang, glad you found this helpful :)
@@madhurbhatia89 speak in Hindi for better explanation
Thank you so much for you SQL videos!!! I'm passing my database class thanks to you.
I love the way you present your tutorials sir
This is the best way to perform an Excel VLOOKUP in SQL, thanks
Suggestion to show both tables on the screen while creating JOIN query
What
Pro tip : watch series at flixzone. I've been using them for watching lots of of movies lately.
@Moses Samuel Definitely, been watching on flixzone for years myself :)
@Moses Samuel Yea, have been watching on Flixzone for years myself :D
IT helped me alot sir keep making vids
but iam 11years trying to learn sql it helped me alot thanks..
Thank you. well understood. Can you please do a video on left joi,right join and outer join
Thanks a ton, This has greatly helped me, I am defintely going to share with my friends who is looking for join tutorial
Also, I just subscribed you
Great tutorial man. Big thumbs up brother!
Thanks for sharing I just learned joins!!!
Thank you ! I view this video twice, and i learned join!
tnx ,you explaind it in a simple way
The second method is called equi join we use = operator and first one is using join keyword . Nice explanation for beginners
That last bit of the video was helpful to really understand the Joins since I use the 'less preferred one but more commonly used' lol didnt event realize it
I'm new to this and you are making it way easier than i imagined. Thank you
Thank you so much for your time and your awesome explanations. Greetings from Lithuania! :)
Hello thank you for you tuto what is the interface that you are using ?
I have a question: what's the name of this new joined table? How can I see it to enable me to query it
By giving example like this you are automatically getting my likes😊
better than my uni professor!
I am having trouble finding help on how to do Insert Into Select w/ join feature .
I have data in table 1, which describes a motorsports racing session. I have table 2 which has information about each of the riders including their bike number, team , manufacturer, name, etc. - both tables have a column Rider ID, where the Riders table (table 2) has Rider ID as the primary key, and on the Table 1 , Rider ID is the foreign key.
I want to write a insert into select join statement that merges in the individual rider data such as bike number, team, manufacturer , and name - into Table 1 . Can you help me please?
Great Tutorial, makes JOINS look easy
Suppose you are given a relation grade points(grade, points), which provides a conversion
from letter grades in the takes relation to numeric scores; for example, an “A” grade could
be specified to correspond to 4 points, an “A−” to 3.7 points, a “B+” to 3.3 points, a “B”
to 3 points, and so on. The grade points earned by a student for a course offering (section)
is defined as the number of credits for the course multiplied by the numeric points for the
grade that the student received.
Given the above relation, and our university schema, write each of the following
queries in SQL. You can assume for simplicity that no takes tuple has the null value for
grade.
a. Find the total grade-points earned by the student with ID 12345, across all courses
taken by the student.
b. Find the grade-point average (GPA) for the above student, that is, the total gradepoints divided by the total credits for the associated courses.
c. Find the ID and the grade-point average of every student.
LODI PA TUTORIAL NGA NITO PARA MAY GUIDE ME SA SUNOD NA ACTIVITY SALAMAT
Simply super bro.. you made my day
Thanks, helped me a lot!
You can actually notice that the amount of results when using an Inner Join is 12, and then after you removed it to use WHERE, it is 13. I was wondering what are you missing out on?
Nice Tutorial, especially when I watch it in 1.5X speed.
Also, This JON example you did, is it an INNER JOIN or OUTTER JOIN?
How do you distinguish these two JOINs in code?
Sahiti Ss exactly , how to distinguish?
Hey Madhur, i see that we got 12 results when we used the Join query, but we got 13 results when we used Where clause, can you explain this briefly ? is it not recommended to use where clause for this kind of queries ?
Khush raho yaaar asan krdeya tumne ❤️
What is the query to find no in ascending or descending order from 2 different tables at the same time?
thank you so mutch the firs method is awsome
Super Like I am a beginner you made it simple Thank You !
what would the query be if I wanted ALL the columns from both the tables? Do I still have to type out each column? Is there a shorter way? like Select * from both tables and join them somehow?
What is the query to find out highest values from 2 different tables at the same time?
Already passed mid-way mark. Great work.
Hi I would like to take sql training from you. Please let me know how much you will charge. Thanks
How can I add column named first name and last name from database employee to table name title with all the data
hi, do i need to put 'AS' in clausing the table? sorry, i'm confused
tbh nobody ever really told me that joins were difficult !i guess it is one of the pros self studying hahahaha
Oh Maaaan, your Turoials are awesome! Thank you!
Hi Madhur, I am trying to create a table in sql workbench where i want create a column where i want to insert ip address but not sure which data type should i select, so could you help me with the correct data type for ip address.
this wasn't bad at all. Thank you,kind sir!
Thanks boss!
This SQL sh*t is light work.
Very useful and straight to point thank you
How to input: films starting with S and T in SQL. Thank you
Did you make id in the second table as primary key?
You didn't explain why ON is preferred over WHERE.
was very helpful simple video!!
Well explain and clear
btw very simple and easy to understand thanks!
Excellent explanation
Really helpful
You explained that really well, thanks
Thank you so much for these tutorials!
Nice tutorial!
no need for triggers, to join 2 tables?
Nicely explained without extra bs
what if we have to write 'officer's name' as a string it will end at officers .
If anyone here can help
I tried following exact the same steps to execute the join command but it didn't work ?
Is that because he populated the id column in the tutorial_info table from the old tutorial or what ??
and if we have to fetch the id column from the old tutorial, what is the syntax for inserting the remaining values (views, likes, dislikes, shares) without writing the id value ? how can we skip that?
its very helpful tutuorial,thanks bro
What kind of sql is this?
I'm using oracle and it's giving me error "from tutorials as t" (@6:06) where t is underlined in red, saying SQL command not properly ended.
What gives?
he is using MYSQL wrorkbench
How can I get sql file like in that video?
can we join more than two tables?
it is just awesome man thanks :)
Love this tutorial, thank you!
@badtutorial What is 'CROSS JOINS'
Very clear, thank you !
Excellent work, The bad Tutorialssssssssss
+Sonia Chavez Thanks for watching!
i don't understand why people don't like the video after watching it?
Thank you
your videoz r vryy helpful!!!
So helpful, thank you!
Great stuff!
Thank a lot 👍👍
Thanks for watching!
can you please provide the insert queries for your table.
(table).(column) = SELECT users.username, users.profiledescription,stats.postcount FROM users,stats;
With Insert you do the same.
INSERT INTO users,stats (users.username,users.profiledescription,stats.postcount) VALUES ('$username','$description','postcount');
You could also do:
INSERT INTO users,stats (username,profiledescription,postcount) VALUES ('$username','$description','postcount');
You need to keep in mind that you can not have 2 same colum names in two tables, if you have 2 same column names you need to specify the table. 'table.username' or 'stats.username'. If you have only a "profiledescription" column inside the "users" table but NOT inside "stats" you do NOT need to type 'users.profiledescription'.
@Edit, before people start crying and leaving shit comments on me, i know that Sai's comment is 1year+ old, this video is from 2014 and i still came hear and learned something. When someone watches this tutorial... he might also ask about the "Insert query"... so here is the answer (above).
You a genius.
I am using Oracle DB and while aliasing a table name i am unable to use AS. I had to use table alias like this " tutorial t".
Is this because of Oracle dialect?
thanks
we can perform join operation only when two table have same number of row and column.
cheers man
awesome
how to rename colunm?
SELECT column_name AS rename
FROM table_name;
It helps,thx.
THANK YOU!
+Billie JL Cheers!
Superb
your name is good.
Assalamualaikum
hi Madhur,
what is ur email id?
Am i the only one who didn't understand much?
nice
👏👏👏
Alright, for those poor bastards out there trying to learning Kusto Query Language where tutorials do not exist, the translation would be:
| join OTHER_TABLE on $right._COLUMN_NAME == $left._COLUMN_NAME
This will merge the two tables where the column name is matches.
Urdu my sikhaen plz
Kya kya bolta hai Bhai Hindi bol Yaar Kuch samjh Nahi kya kya Kiya
thank you.