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
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?
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
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?
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?
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 ?
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.
(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.
Saw a thousand videos but didnot understood why joins arw written like that and your one video made me clear everythingg.. Thank youu
Great tutorial. I was pretty intimidated by JOINS but you made it nice and simple. Thanks man
Watching in 2024😢
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.
One of the simplest and yet ery helpful tutorial Ive found! thanks man! keep this up :)
Very simple and to the point explanation of how JOINS work in SQL.
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
IT helped me alot sir keep making vids
but iam 11years trying to learn sql it helped me alot thanks..
This is the best way to perform an Excel VLOOKUP in SQL, thanks
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!
Khush raho yaaar asan krdeya tumne ❤️
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
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
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
Simply super bro.. you made my day
better than my uni professor!
Thank you so much for your time and your awesome explanations. Greetings from Lithuania! :)
Thanks, helped me a lot!
The second method is called equi join we use = operator and first one is using join keyword . Nice explanation for beginners
By giving example like this you are automatically getting my likes😊
Super Like I am a beginner you made it simple Thank You !
I'm new to this and you are making it way easier than i imagined. Thank you
Thank you. well understood. Can you please do a video on left joi,right join and outer join
Already passed mid-way mark. Great work.
Great Tutorial, makes JOINS look easy
thank you so mutch the firs method is awsome
Thanks boss!
This SQL sh*t is light work.
was very helpful simple video!!
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!
Excellent explanation
Very useful and straight to point thank you
Well explain and clear
this wasn't bad at all. Thank you,kind sir!
Nice tutorial!
btw very simple and easy to understand thanks!
its very helpful tutuorial,thanks bro
You explained that really well, thanks
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
Hello thank you for you tuto what is the interface that you are using ?
Thank you so much for these tutorials!
it is just awesome man thanks :)
I have a question: what's the name of this new joined table? How can I see it to enable me to query it
your videoz r vryy helpful!!!
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
Really helpful
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?
How can I add column named first name and last name from database employee to table name title with all the data
What is the query to find no in ascending or descending order from 2 different tables at the same time?
What is the query to find out highest values from 2 different tables at the same time?
Love this tutorial, thank you!
Nicely explained without extra bs
How to input: films starting with S and T in SQL. Thank you
Great stuff!
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?
You a genius.
Hi I would like to take sql training from you. Please let me know how much you will charge. Thanks
hi, do i need to put 'AS' in clausing the table? sorry, i'm confused
Very clear, thank you !
So helpful, thank you!
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 ?
Excellent work, The bad Tutorialssssssssss
+Sonia Chavez Thanks for watching!
Thank a lot 👍👍
Thanks for watching!
How can I get sql file like in that video?
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.
no need for triggers, to join 2 tables?
Did you make id in the second table as primary key?
what if we have to write 'officer's name' as a string it will end at officers .
can we join more than two tables?
You didn't explain why ON is preferred over WHERE.
cheers man
👏👏👏
Superb
It helps,thx.
i don't understand why people don't like the video after watching it?
@badtutorial What is 'CROSS JOINS'
thanks
awesome
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).
THANK YOU!
+Billie JL Cheers!
how to rename colunm?
SELECT column_name AS rename
FROM table_name;
thank you.
we can perform join operation only when two table have same number of row and column.
Assalamualaikum
nice
your name is good.
Watching in January 2025
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.
hi Madhur,
what is ur email id?
Am i the only one who didn't understand much?
Urdu my sikhaen plz
Kya kya bolta hai Bhai Hindi bol Yaar Kuch samjh Nahi kya kya Kiya