Can we replace right join with left join
Vložit
- čas přidán 5. 09. 2024
- Why is right join required when we have left join | use of right join | why use right join instead of left join | is right outer join ever required | difference between left outer join and right outer join in sql | do we really need both left join and right join | Left vs right sql join
Notes and Slides
www.pragimtech...
SQL Server Tutorial for beginners course page.
www.pragimtech...
SQL Server Tutorial for beginners playlist
• SQL Server tutorial fo...
SQL Server Interview Questions and Answers
• SQL Server Interview Q...
SQL Server Performance Tuning and Query Optimization
• SQL Server Performance...
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✍😇🤴💯🥳🙏
Please continue performance tuning series ❤️
You have ubnormal skill in teaching. We expect more videos on sql performance.
Waiting for your performance tuning video.. Please 🙏continue on that post..
Hi Venkat, good to see these video again from your channel.
Could you please give a sql tuning video with interview question(concurrently)
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.
Please continue performance tuning series
Sir, could you please continue performance tuning videos.
Thanks for sharing valuable knowledge. Please make videos on Performance Tuning with some real time scenarios. Thank you in advance !
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 ? "
Thank you Venkat for this great video, I always learn a lot from your video.
Please making video on Microsoft Azure?
Thank you sir ji
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.
Hello sir, please continue performance tuning series as well
Performance tuning please 👍👍👍
Hi have always used your sql videos, since 2016, Would you please start session on the DB administration and also Power BI if possible.
Thank you very much...
This question I have asked in the interview
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.
SQL string function video plz
Thanks to you sir... proud of you
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?
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 we can seperate positive and negative numbers from only one column in table is given
Please do a video on token based web api
Oauth in web api .
Thanks
Thank you, sir!
Great video! Can you do a video on filestream ?
Thank you Vankat, great video as always.
You have patreon?
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..
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
Superb sir
How to do partitioning in SQL please. Explain
Good info.
Super ♥️
Inner join