Sir....u told that in inner join 1st table is of left join(userinfo) and right table is of (stateinfo) and then again u r telling that 1st table we are joining is of right join and second one is of left join...it is little bit confusing....could u please sort it out sir
Hello sir I have watched all of your SQL it was too good😊. Sir if possible could please upload one video on how to import data from Excel files..thank you 🙏
Thanks you for full information , we need some more help from your end that is please suggest a platform to practice real time scenario based queries. with solutions
for inner join mari table b lo 5 vundi ga aadi output lo 2 tho replace aendi how what about those values then.aakada a number vuna kuda inner join chestey stateid both ki same a vostaya.
Hi,sir I have one doubt please clarify me. While inserting values of district id 1 to the userprofiledetails table,I am getting error as we dont have districtid as 1 in districtinfo. please clarify
For inner join what is the diffrence between these 2 queries will it return with different serial numbers or same? SELECT* FROM Categories JOIN Products ON Categories.CategoryID = Products.CategoryID; SELECT * FROM Products JOIN Categories ON Products.CategoryID = Categories.CategoryID;
Hi Sir, I have small doubt actually in the table i saw 2 null values is there right how can I write null values in query can you please send me the query.
Hello sir, am getting an error Msg 245, Level 16, State 1, Line 73 Conversion failed when converting the varchar value 'Anantapur' to data type int. can you please help how to resolve the isseu
Sir....u told that in inner join 1st table is of left join(userinfo) and right table is of (stateinfo) and then again u r telling that 1st table we are joining is of right join and second one is of left join...it is little bit confusing....could u please sort it out sir
First table(userinfo) is left join and second table(stateinfo) is right join. I think by mistake i misspelled at the end
REALLY DUDE YOUR ARE THE 1ST ONE TO EXPLAIN SQL JOINS IN A VERY EASY UNDERSTANDABLE WAY IN ENTIRE TH-cam
SIR REALLY FANTASTIC..NENU DATASCINCE VADILEYALI ANUKUNNA..EE SQL ARDAM KAAKA..KAANI CHAALA EASY GA CHEPPARU.IPPUDU NAAKU ANIPISTUNDI..NAAKU SQL LO JOINS MTRAME VACHU ANI..
Actually iam going to sql class. but i get full clarity by this video tq bro 👌👌👌 explanation
After long back I understood how to join the tables easily. Thank you so much sir
seriously this series helps me a lotttttttttttttttttttttttttt, a big thanks bruhhhh
bro u r simply superb in explanation.....grade 1 professors are not explaining in the best way as u do in the video......thank you soo much anna..
Your teaching skills is Next level brother love you keep post more videos
Very comprehensive Teaching with tables. Thanks. looking forward for more videos
very nice explanation. 1st 5 min for basic join concept and remaining for advanced join concept. mmm.... 🙂
Bro Nice explaination . Didn't exepected these type of explanation from a Telugu TH-cam channel. Keep Sharing Info, Tysm!
chala baga chepparu sir simple ga arthamai poyendi thanq sir
The way of your Explantion is Wonderful.. 👌👌👌Sir..Tqq
Thank you so much 🙏🙏🙏
Baga cheparu sir in very simple terms. Thank you.
Hello sir I have watched all of your SQL it was too good😊. Sir if possible could please upload one video on how to import data from Excel files..thank you 🙏
chala baa chepparu sir, very useful, Thank you.
Chala baga chepparu anna thank you❤🎉🎉
Chla chla baga chpar sir thank you so much for your efforts 👏
Tq it's very easy to understand joins
Thank you so much ❤ for helping us to explaining in essy way
Thank you for the Video Sir ❤
Nice explanation bro
ur explanaion is very well
Thanks you so much sir. Actually I absent join cls. it's so usefull
its very usefull thank u sir
Tq sir superb explanation.tq so much
Excellent explanation sir😊
Excellent Explanation brother 👍👍
you are a god .
Thanks for good explanation
content is pure gold
Excellent Bro.. Nice explanation.
Thanks you for full information , we need some more help from your end that is please suggest a platform to practice real time scenario based queries. with solutions
Love you brother for your teaching skills
Really good
best videos in telugu
good teaching sir
Bro very useful 🙌
u explained very usefull to me...
Nice explanation bro...Keep on posting videos like this, it might be helpful people like me...
awesome sir
super cheppinav anna
super teaching brother
Thanks bro good understanding
very big thank you bro this session helps me a lot
Good explanation !!
Excellent bro hope u make more videos on SQL
super explaination, with clear understanding
Thank you
super teaching
Superb sir
for inner join mari table b lo 5 vundi ga aadi output lo 2 tho replace aendi how what about those values then.aakada a number vuna kuda inner join chestey stateid both ki same a vostaya.
Nice
thankyou sir
super explain
TX sir 🎉
DESCRIPTION LO TABLES YOKKA QUEREY PETTANDI SIR S0 IT WILL BE HELP TO PRACTISE EASILY
TQ SO MUCH ,
Please post the video of the concept "performance tuning in SQL server "
Super explanation
Bro plz sub queries and t-sql kuda explain cheyandi
Superb
Cross join video cheyyandi plz
Sql interview queries and questions video cheyandi anna
bro i have small doubt 6th row match avvaledhu gaa broo how broo
sir in userprofiledetails table how to write like that hobbies in multiples do a video sir at 19.55 timing
Hi,sir I have one doubt please clarify me. While inserting values of district id 1 to the userprofiledetails table,I am getting error as we dont have districtid as 1 in districtinfo. please clarify
NICE VIDEO
Pls upload more SQL videos
Now a days most interviewers asking tricky joins questions what is output dificult to answers in little time
Bro JOIN concept use chesinapudu,
rendu tables lo same column names untey ney join cheyagalama
24:31 districtid but table lo captial letters undi problem em kada?
Sql is not case sensitive language so no problem occurs
Sir SQL triggers and stored procedures meda emaina video unda
CTE py oka video cheyandi broo please
For inner join what is the diffrence between these 2 queries will it return with different serial numbers or same?
SELECT*
FROM Categories
JOIN Products ON Categories.CategoryID = Products.CategoryID;
SELECT *
FROM Products
JOIN Categories ON Products.CategoryID = Categories.CategoryID;
this sql is enough for bip reports ..or any advanced is there like my sql/pl sql pls let me kno
Anna case condition meeda kuda Ila simple ga video cheyava
Hello sir cross join gurinchi chepadam marichipoyaru
1st table and 2 nd table state I'd different ga undi kada Ela same ayay sir
Hi Sir,
I have small doubt actually in the table i saw 2 null values is there right how can I write null values in query can you please send me the query.
hlo.....bro .....same problem for me also......
if u get that solution...please tell me tooo.
Sir..i tried but Join only table headlines not inner detail data...what is the problem
Anna nuvvu chesina tables syntax kavali anna
can u explain concept in JOINS
❤
sir actually when iam using both int,nvarchar it showing error can you resolve it please
Sir please provide data tables also for practice.
Hi Brother can you paste whole script in the comment
🥰🥰🥰🥰
Rendu primary keys tho join cheyalema
Do more videos
without foreign key also we can join two tables
Hello sir, am getting an error
Msg 245, Level 16, State 1, Line 73
Conversion failed when converting the varchar value 'Anantapur' to data type int. can you please help how to resolve the isseu
Bro BigData with AWS leva projects..?
A software use chestunnaru sql ki
give me that tables in description bro plzzzzzzz
Anna pl/ sql videos cheyuu Anna
Chala easy ga cheptunnaru baga ardham ayitundhi
Could you please share those table
Can you explain one SQL project
i want your material will you provide any material