Thank you Venkat. I have seen all your previous sql videos. Good to see that you've started again with more presentable way. Pls create videos on new functions in sql.
Can anyone please tell in video 17 of this Playlist, it was told that all inner, left, right, full and Cartesian joins return same row count but here in this video, it is not the same where different joins have different row counts like inner have 2 rows and left and right have 3 each.. why it is like that.. Can anyone please say..
Nice video. Thanks for sharing. Actually this is also a good interview question " Can we achieve the same result in Left Join instead of Right join or vise a versa without affecting performance ? "
Hi Sir, Is there an example where both left and right join can be used together as you mentioned in a scenario with 3 or more table joins is required. Can you show an example to understand. It will be very helpful.
I was aked to return students who have not paid fee for the 6th month without using NOT EXIST and NOT IN.. There were two tables of Student and StudentFee with student_id as foreign key in StudentFee Table.
It would be easier to answer if you could provide both the Table's structure, preferably with Data. Till then I'm assuming "StudentFee" Table has 2 Columns- "FeeDate" of DateTime type and "Student_ID" of int type acting as the Foreign Key. And "Student" Table has 2 columns - "Student_ID" of int type as the Primary Key and "StudentName" of varchar(50) type. I'm also assuming the "FeeDate" Column of "StudentFee" Table has records comprising of multiple dates and not just dates for the 6th month, and January is the month of start of Academic Year according to which 6th month would be = June, if 6th month in your case is different based on different starting month of Academic Year then you need to replace the value of month accordingly--> With cteGetStudentNames As ( Select * From StudentFee Where MONTH(FeeDate) = 6 --This value represents June, change this value according to your 6th month ) Select Student.StudentName From cteGetStudentNames Right Join Student On cteGetStudentNames.Student_ID = Student.Student_ID Where cteGetStudentNames.FeeDate IS NULL
All your videos and lectures are so easy to understand. I learnt a lot from you. I'm a software engineer now. Thank you so much.
Thank you Sir
We are waiting the sql performance series.
I’ll leave the guy alone. He already addressed this 100 times
@@chezchezchezchez
You know Performance is required for every where, he already shared videos about it, but if possible we would like more 🙂
Thank you venkat your just Awesome nothing can match your level of perfection✍😇🤴💯🥳🙏
Thank you Venkat. I have seen all your previous sql videos. Good to see that you've started again with more presentable way. Pls create videos on new functions in sql.
You have ubnormal skill in teaching. We expect more videos on sql performance.
Please continue performance tuning series ❤️
Hi Venkat, good to see these video again from your channel.
Could you please give a sql tuning video with interview question(concurrently)
Sir, could you please continue performance tuning videos.
Waiting for your performance tuning video.. Please 🙏continue on that post..
Please continue performance tuning series
I was asked in an interview if LEFT JOIN can do the same task as RIGHT JOIN by reserving the order of the tables in join, why does RIGHT JOIN exists?
Can anyone please tell in video 17 of this Playlist, it was told that all inner, left, right, full and Cartesian joins return same row count but here in this video, it is not the same where different joins have different row counts like inner have 2 rows and left and right have 3 each.. why it is like that.. Can anyone please say..
Thank you Venkat for this great video, I always learn a lot from your video.
How we can seperate positive and negative numbers from only one column in table is given
Nice video. Thanks for sharing. Actually this is also a good interview question " Can we achieve the same result in Left Join instead of Right join or vise a versa without affecting performance ? "
Hi have always used your sql videos, since 2016, Would you please start session on the DB administration and also Power BI if possible.
Hi Sir, Is there an example where both left and right join can be used together as you mentioned in a scenario with 3 or more table joins is required. Can you show an example to understand. It will be very helpful.
Thanks for sharing valuable knowledge. Please make videos on Performance Tuning with some real time scenarios. Thank you in advance !
Please making video on Microsoft Azure?
Sir, how can we add row number to table without using row_number fucntion just like rowid in oracle, please create video on it.
How to do partitioning in SQL please. Explain
Please make a video on how to join tables without using JOIN clause
Use views
You can use the comma ( , ) operator instead of Join clause.
Thanks to you sir... proud of you
Thank you very much...
SQL string function video plz
Hello sir, please continue performance tuning series as well
Thank you, sir!
Thank you sir ji
This question I have asked in the interview
Great video! Can you do a video on filestream ?
Thank you Vankat, great video as always.
You have patreon?
I was aked to return students who have not paid fee for the 6th month without using NOT EXIST and NOT IN.. There were two tables of Student and StudentFee with student_id as foreign key in StudentFee Table.
It would be easier to answer if you could provide both the Table's structure, preferably with Data.
Till then I'm assuming "StudentFee" Table has 2 Columns- "FeeDate" of DateTime type and "Student_ID" of int type acting as the Foreign Key. And "Student" Table has 2 columns - "Student_ID" of int type as the Primary Key and "StudentName" of varchar(50) type. I'm also assuming the "FeeDate" Column of "StudentFee" Table has records comprising of multiple dates and not just dates for the 6th month, and January is the month of start of Academic Year according to which 6th month would be = June, if 6th month in your case is different based on different starting month of Academic Year then you need to replace the value of month accordingly-->
With cteGetStudentNames
As
(
Select * From StudentFee
Where MONTH(FeeDate) = 6 --This value represents June, change this value according to your 6th month
)
Select Student.StudentName
From cteGetStudentNames
Right Join Student
On cteGetStudentNames.Student_ID = Student.Student_ID
Where cteGetStudentNames.FeeDate IS NULL
Good info.
Please do a video on token based web api
Oauth in web api .
Thanks
Super ♥️
Superb sir
Performance tuning please 👍👍👍
Inner join