The way he answered is very good but he got confused with left join and right join. In left join it returns all the values from left table and common values from right table and in right join it returns all the values from right table and common values from left table.
Great! I was surprised that he has a non-tech background, the way he explained all the SQL stuff was incredible. His presence of mind and communication was excellent. I am proud and inspired by it. 👏👍And Thank you sir for sharing such inspiring videos with us.
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
@@LotusITHub Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
Amazing interview.I will improve my skills from this video. I saw Candidate confidence and body language is very good .this video will help me to improve skills and confidence. Thank you nilesh sir🙏
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
Interviewer don't have enough knowledge on his English speaking skills rather than that the person who give interview have good command on his English language.
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table. follow me for more .i will be making good videos for student.
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
I know this all about the sql , data visualisation in excel ,powerbi , python, R , Data cleaning still not able to get the internship. Can anybody here tell me what am I missing? Or how to approach others(company )for the internship . It will be off great help;)
It is correct, he wrote using subquery, and if u use limit u will get one output of 2nd highest salary, whereas in table maybe more than 1 person having 2nd highest salary
Answer given for RIGHT outer join is totally wrong.right answers is RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table. FOLLOW ME FOR MORE SQL KNOWLEDEGE
Very useful, helpful and appreciable as I am also trying to switch my career into SQL with non tech background.
Thank you jitendra , Best Wishes for your Future
Pp szszs@@LotusITHub
The way he answered is very good but he got confused with left join and right join. In left join it returns all the values from left table and common values from right table and in right join it returns all the values from right table and common values from left table.
ok thank you dear comment and valuable
It is a best composition for beginners to learn how to give your interview. Always be confident whether you are right or wrong.
Thank you Jaishree😊
Great! I was surprised that he has a non-tech background, the way he explained all the SQL stuff was incredible. His presence of mind and communication was excellent. I am proud and inspired by it. 👏👍And Thank you sir for sharing such inspiring videos with us.
Thank you Divya
Can good
Best class
Thank you Divya 😊
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
Very helpful interview for the college students or freshers because it's only fear for the students
Thank you bhumika 😊
@@LotusITHub Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
I think he is not a fresher although the questions are very helpful for freshers
Thank you so much
i have ssen first interview in which the interviewer seems nervous asking questions from candidate.😅😅
exactly. interviewer looks like fresher and fresher looks like interview
Amazing interview.I will improve my skills from this video. I saw Candidate confidence and body language is very good .this video will help me to improve skills and confidence.
Thank you nilesh sir🙏
Thank you akshay 😊
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
This was great and for sure increase my confidence 😊
Interviewer don't have enough knowledge on his English speaking skills rather than that the person who give interview have good command on his English language.
Good one , it’s very helpful …candidate looks like prabhas😀😀
Thank you, sir please upload mock Interview for java
This was so helpful. This interview boosted my confidence. Thanks a lot
@@kunalmanwar1615 thank you 👍
sir ap puchte gaye main video pause karke jawab deta gaya ... very resourceful content thankyou
Ok dear
Ok will have some more interviews
Thank you Ashish 😊
Very Helpful , thank you
Thank you shree 😊
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
follow me for more .i will be making good videos for student.
❤️👍 best wishes
Very useful information regarding interview 👏👏
Thanks a lot
For which job role this interview helps...
Informative, Can we say query in place of command.
SQL means structure query language
So query is better
Left join and right join is not correct
Thank you for makeing this types of video ❤
It will boost our confidence as well as knowledge
Thank You pankaj
Very nice Nilesh sir
Thank you Pradip 😊
it was helpful
Actually this is a mock interview in Actually even if u are little bit nervous it's okay
Thank you ayush for comment,will sure improve
4.32 wrong..thee rowid is same
Very nice video..thankyou for guidance 🙏🏻👍🏻
Thank you bhumika 😊
useful next javascript? wi8ing...
Yes, definitely
can anyone help me with building resume from non tech to IT background
Nice
Thank you 😊
Didn't give the right answer of joins of left join and right join
ok thank you
Helpful ❤❤
I'm glad!
Sir left and right ko ulta define karr dia..kindly check n correct
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
How can i give this interview ??
I know this all about the sql , data visualisation in excel ,powerbi , python, R , Data cleaning still not able to get the internship.
Can anybody here tell me what am I missing? Or how to approach others(company )for the internship . It will be off great help;)
use linkdin ....or search for company websites...
If you need any kind of help for internship then you can contact me
Which platforms u apply through??
Sql is enough to get job?
Yes sql dev
Second highest salary query is wrong he needs to give limit or offset
It is correct, he wrote using subquery, and if u use limit u will get one output of 2nd highest salary, whereas in table maybe more than 1 person having 2nd highest salary
From where u learned sql?
Answer given for RIGHT outer join is totally wrong.right answers is
RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table.
FOLLOW ME FOR MORE SQL KNOWLEDEGE
Lgta he USA mein aa gya ,by by