I guess Im asking randomly but does any of you know a way to log back into an instagram account?? I stupidly lost my password. I would appreciate any tips you can give me
Wow, just wow.... With you sir, I would say I am a proud QA Engineer/Data Analyst/Developer in view. All your videos are well explained. More grease to your elbow. Thanks so much.
Thank You. I can actually understand you The SqL boot camp intro one was good but after that it took me a while to find a good video that goes more in dept about nested query and or advanced query searches. Than I stumbled on to yours. you are one of the best instructors I found so far and I will keep watching yours.
Thanks a lot sir 🙏. Your explanations are incomparable. Many would've faced lot of issues in understanding complex queries. But you made it understand like a piece of cake. You are awesome sir
What a wonderful explanation of the complex topic in SQL. I am really thankful to you. I have learnt a lot from your other videos too. Thank you so much!
Sir, your explanation is fantastic even a dumb guy can understand in that way , thanks a lot sir you deserve guru. Guru Brahma guru vishnu guru devo maheshwara guru sakshath parabrahma thasmaishree guravenamaha.🙏🙏🙏
Sir in the last example you missed a ,comma before salary and after first name . So the salary name was applied as alias for the first name instead of getting salary table.
I think at 8:55 duration of this video, Left Outer join = Returns matched records + unmatched from left table table 1 right outer join = Returns matched records + unmatched from right table table 2 can you clarify it ??
Sir your are teaching is wonderful you are saved my life. I have one suggestion sir please provide the mysql material pdf sir. That pdf is also helpful to many people
I have a doubt at 36:35 I.e., when you are deriving data from both the tablets it should be like from e.employee, m.manager right but you have mentioned as from e.employee, m.employee.. am bit comfused
Found Mistake in your Tutoiral 9. You said Right outer join as "Returns matched records + unmatched from right table Tab1". So here I am making correction as "Returns matched records + unmatched from right table Tab2" Also, in the same way for left join. Please correct me if I am wrong
smjh hi nhi aya 21:29 mein k department id is ambiguous dono table mein departmnt id jb h r maine table name b defined krdiya h to chup chap se dono table se deprtmnt id lekr inner join krdeta na
sir when I run this query SELECT E.employee_id, M.manager_id, E.first_name, M.first_name, E.job_id FROM employees E, employees M WHERE E.employee_id = M.manager_id; I got different record for the first_name field. I think the field record for E.first_name, and M.first_name should be the same so far both alias are referring to the single firs_name field in employees table Awaiting your response sir. Thanks
hey did you get the answer, i am jsut learning from these videos n as per my understanding, data type should b shame for join function, if i m wrong, please correct me
on the last problem, line 11 (,) comma is missing between First_Name and salary ... which is why is not printing the salary instead it's used as an alias name of the First_Name... Thanks
5 years are completed still sir are you not provide the any link of practice purpose of HR Database Or you can you provide the link+ some amount of which is use full for both us Thank you.
sry lekin srusly kahun toh mjhe smjh hi nhi aya join aisa confuse krdiya aone yahan pr aakr jb mera employees table mein deprtmnet id h r department table mein department id h toh inner join jb kiye toh simply ans miljana chhye na qki ur query was SELECT FIRSTNAME, SALARY, DEPARTMENT ID FROM EMPLOYEES U HAVE MENTION HERE FROM EMPLOYEES TOH PHR ISME APNE KAHA K DEPARTMENT.DEPARMENT ID EMPLOYEES TABLE K ANDR DEPARTMENT TABLE R USKI DEPRTMNT ID
confusion from 1.02.55 someone please help me to understand this 'the whole salary is less Then 1400 ' but some salary is more then the salary of id_30
OMG THIS VIDEO LITERALLY SAVED MY LIFE!!! I have an exam on SQL tomorrow and I feel a lot more confident
Good luck!!
I guess Im asking randomly but does any of you know a way to log back into an instagram account??
I stupidly lost my password. I would appreciate any tips you can give me
@@cashali4747 yahi kam kr beta 🤦
Kitna khokha Mila hai 😂
Best study channel in the whole TH-cam study channels
Thanks
Wow, just wow.... With you sir, I would say I am a proud QA Engineer/Data Analyst/Developer in view. All your videos are well explained. More grease to your elbow. Thanks so much.
Hi guys why you dislike ? HE SHARING his knowledge please like like like positivity is better
Thank You. I can actually understand you The SqL boot camp intro one was good but after that it took me a while to find a good video that goes more in dept about nested query and or advanced query searches. Than I stumbled on to yours. you are one of the best instructors I found so far and I will keep watching yours.
you are the best in this industry... no tutorial can beat this one in particular... Thanks a ton sir
welcome
Thanks a lot sir 🙏. Your explanations are incomparable. Many would've faced lot of issues in understanding complex queries. But you made it understand like a piece of cake. You are awesome sir
You are most welcome
Among all videos on you tube, you made me understand these things better.
very true ,im now starting to follow up on all his videos now
What a wonderful explanation of the complex topic in SQL. I am really thankful to you. I have learnt a lot from your other videos too. Thank you so much!
very good explanation. the best part about his explanation was that he divided the question into small parts so that it was very easy to understand.
My pleasure
I understood this joins concept by him after watching hundred other videos.. Thank you
Yes super explanation
It is helpful to understand the concept for beginners. Superb....
Sir, your explanation is fantastic even a dumb guy can understand in that way , thanks a lot sir you deserve guru. Guru Brahma guru vishnu guru devo maheshwara guru sakshath parabrahma thasmaishree guravenamaha.🙏🙏🙏
My pleasure
wow excellent content very easy to follow
Glad you liked it
Sir your teaching is very good.I appreciate it ❤
It's my pleasure
I am thankful for you sir. This will help me in my SQL class.
Welcome
Wow super explanation sir
Thank you so much
Best join and sub query video in TH-cam. Thanks a lot sir. It's help me a lot for my interview.
R u become software test engineer
one of the best tutor i found thank u sir for giving this kind of deep knowledge
Welcome
Hats off to you...
You made complex queries so smooth...anyone can understand and perform....
Thanks
Sir in the last example you missed a ,comma before salary and after first name . So the salary name was applied as alias for the first name instead of getting salary table.
u r the best sir,i learnt lot from ur testing videos
Thanks
Thanks a lot sir for tutorials, helped me a lot to understand joins🙏
Welcome
Thanks a lot for such a clear explanation 🙏 I have understood it clearly....
Thank you very much sir for ur wonderful explanation
You are most welcome
realy your explaination is better than any other platform , realy amazing
Thanks
Thank you so much Sir you are the best teacher in youtube i have done manual testing course from your channel and now learning MySQl.
most welcome
I am just beginner and it was really helpful
Glad it was helpful!
Excellent lecture
Thanks
@1:19:36,
Kindly provide comma(,) between FIRST_NAME and SALARY. Because at output SALARY has become as Alias name to FIRST_NAME column
Was searching for this comment.😀
Superb explanation Thank you so much sir👍
Welcome
awesome explanation sir!tomorrow i can perform well in my lab examination
Thanks
SELECT * FROM EMPLOYEE WHERE SALARY
but some salary in > any is not correct as per my understanding could you please help me to to understand this one
Excellent lectures... 👏
thanks
Sir aapko bahut bahut pranam
thanks
Tq sir tq so much I really like ur way of explanations.. it is very clear and understanding
welcome
Will u please provide the important interview questions on this topic just like mcqs
Hi sir the video is very useful and awesome.can we get data which ur using into the video for using queries.
it's very helpful video to fresher.
thanks
Thank you sir . It was very helpful sir.
Most welcome
Thanks Pavan sir 21:00 sec
Welcome
This will make more sense and will be helpful if you can provide HR database link from where we can import. thanks
github.com/nomemory/hr-schema-mysql/find/master
Hi Sir, I never seen like this kind of explanation. Can you please make python logical programming videos?
I think at 8:55 duration of this video,
Left Outer join = Returns matched records + unmatched from left table table 1
right outer join = Returns matched records + unmatched from right table table 2
can you clarify it ??
Same doubt, think it's writing error
video is helpful but you gave only overview of join and did not do problems on that ....although my subquery concept is now more
clearer
Sir your are teaching is wonderful you are saved my life. I have one suggestion sir please provide the mysql material pdf sir. That pdf is also helpful to many people
www.pavantestingtools.com/p/sql-tutorials.html
Tq so much sir
this is we call the perfect explanation. Thank you so much sir.
You are most welcome
Thank you for the detailed explanation Sir
Welcome
SIR SUPER EXPLANATION,, IF YOU PROVIDE SAME DATA,, IT WILL BE BEST FOE US TO PRACTISE THE SAME..
Thank you so much
You're most welcome
Tq so much sir really very awesome contributions to make vedio
Im appreciate
It's very to understand and lern
welcome
I have a doubt at 36:35 I.e., when you are deriving data from both the tablets it should be like from e.employee, m.manager right but you have mentioned as from e.employee, m.employee.. am bit comfused
very detailed explanation thank you
Welcome
Sir if we want to know the second high salary we can keep assending order and the result will come know sir
Found Mistake in your Tutoiral 9. You said Right outer join as "Returns matched records + unmatched from right table Tab1". So here I am making correction as "Returns matched records + unmatched from right table Tab2" Also, in the same way for left join. Please correct me if I am wrong
yeah u are crct
Thanks ,could you please tell what is the difference between MySQL ,SQL and Oracle.
MySQL and oracle are the RDMS were in sql is a query language used to create and maintain RDMS.
thanks for the explanation video it's really useful
You are welcome
smjh hi nhi aya 21:29 mein k department id is ambiguous dono table mein departmnt id jb h r maine table name b defined krdiya h to chup chap se dono table se deprtmnt id lekr inner join krdeta na
Sir, In multi row query any is giving all the department_id not just 30... I don't understand why??
There is a typo in left outer join. Left join =inner join +any additional records in the left table. not the right table,
Yes correct, I was pitching my head looking at the wrong results😬
sir, cam we please get the presentation if possible?
at 1:21:46 why in rsult colum didnt mention first_name ,which was commended
Awesome explanation😄😃
Thanks
Sir can you please provide more examples means like different examples so that we can practice
How can I purchase full courses from your channel please ?
sir when I run this query
SELECT E.employee_id, M.manager_id, E.first_name, M.first_name, E.job_id
FROM employees E, employees M WHERE E.employee_id = M.manager_id;
I got different record for the first_name field. I think the field record for E.first_name, and M.first_name should be the same so far both alias are referring to the single firs_name field in employees table
Awaiting your response sir. Thanks
Table A having float as data type and Table B having varchar as a data type can we join these table?
hey did you get the answer, i am jsut learning from these videos n as per my understanding, data type should b shame for join function, if i m wrong, please correct me
Excellent!
Many thanks!
on the last problem, line 11 (,) comma is missing between First_Name and salary ... which is why is not printing the salary instead it's used as an alias name of the First_Name...
Thanks
Sir my humble request please increase quality(360p)
5 years are completed still sir are you not provide the any link of practice purpose of HR Database
Or you can you provide the link+ some amount of which is use full for both us Thank you.
why do we bother using self join, we can anyways just use where clause and get the work done?
Hi Sir, can i get these SQL queries with db test data?
"Äny " would print the same employee twice, is not it? because the employee having the salary 2000 is lesser than any of the department 30 salary.
someone :- Pavan how do you know joins soo clearly
Me :- i follow my man SDET 😛
Sir I have a doubt .. can u please clear it out?
How I get all SQL videos ? Plz share a link of all videos
How to find 6th maximum salary ?
Sir where are the rest my sql videos ?
How to find 7th max highest salary in Employee table ?
where do i get hr database
i need hr database sir
sir can you please share link of Demo database hr link so we can practice on that
Hi guys how to find the 3rd highest salary from employee table using joins.
It's good
Thanks
When we use only join command
sir please provoid hr data .link sir
To be honest it wold have been so nice if you had shared all the datas you had. so many different datas and I have non of it
can you plz provide the ppt
Every time, I am using this command I am getting an error like 1146, table doesn't exist. How to resolve it. Please help in resolving this issue
38:12
sry lekin srusly kahun toh mjhe smjh hi nhi aya join aisa confuse krdiya aone yahan pr aakr jb mera employees table mein deprtmnet id h r department table mein department id h toh inner join jb kiye toh simply ans miljana chhye na qki ur query was
SELECT FIRSTNAME, SALARY, DEPARTMENT ID FROM EMPLOYEES U HAVE MENTION HERE FROM EMPLOYEES TOH PHR ISME APNE KAHA K DEPARTMENT.DEPARMENT ID EMPLOYEES TABLE K ANDR DEPARTMENT TABLE R USKI DEPRTMNT ID
While executing same code in my system. It is showing error as Error Code: 1242. Subquery returns more than 1 row. Can any one tell reason ?
confusion from 1.02.55 someone please help me to understand this 'the whole salary is less Then 1400 ' but some salary is more then the salary of id_30
For 2nd max salary, select salary from employees order by salary desc limit 2,1;
Display the employees who all earning the highest salary here can we use this
SELECT * FROM EMPLOYEES WHERE SALARY=MAX(SALARY);
Hi Sir can you please add me in the google group please