Hello, I have a question here. In 3:27 the number 7654 in the saleman_employee_number is not included in the IN statement, unlike 7499 and 7521. Please advise. Thank you in advance.
Hi Nadia, The initial "IN" statement just chose some random employees. The subquery is returning employees that have actually made sales. Employee 7369 did not make a sale. Employee 7499, 7521, and 7654 made sales.
Joey, Dumb question perhaps but I missed this. I am referring to the Sub-query section of this video. How can you display the column employee_number in a specific position in the table when you run the code ? For instance, say I want to insert the Employee_number to appear after the job title "Salesman" P.S as I write. I am in a college introduction SQL class and have recommended your video series to classmates as one of the best I have found. Thanks for your hard work.
i think you need to intially create table where the position of the column emplee_number stands after the job title. about the question 'How can you display the column employee_number in a specific position in the table when you run the code?' Answer: you need to create foreign key that references column employee_number from table employee with column salesman_employee_number from table customer
short, simple, and easy to understand.
Thank you so much, I'm learning a lot from your SQL Training videos. The way you present the lesson is simply amazin!!! God bless you!!!
شكراً جزيلاً لك ... لقد كان درساً مفهوماً بشكل واضح .
.Thank you very much ... It was a lesson that is clearly understood
I really like your lecture. It is simple but easy to understand. You are the BEST, thanks!! :)
Thanks again Joey Helping me so much with your vids
Nice, very understandable.
Very helpful! Thank you so much! Very straight forward and easy to follow and understand.
O thanks..this video was a life saver
Awesome 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Thank you from South Korea
Thanks a lot ,so helpful...
Quick and informative
easy and precise thanks buddy
amazing explanation - thank you!
Very helpful for me, 10x
it was really helpful thank you
Thanks for sharing
Hello, I have a question here. In 3:27 the number 7654 in the saleman_employee_number is not included in the IN statement, unlike 7499 and 7521. Please advise. Thank you in advance.
Hi Nadia,
The initial "IN" statement just chose some random employees. The subquery is returning employees that have actually made sales. Employee 7369 did not make a sale. Employee 7499, 7521, and 7654 made sales.
THANKS AGAIN SIR
Character In the video It's great, I like it a lot $$
Thank you so much
Joey, Dumb question perhaps but I missed this. I am referring to the Sub-query section of this video. How can you display the column employee_number in a specific position in the table when you run the code ? For instance, say I want to insert the Employee_number to appear after the job title "Salesman"
P.S as I write. I am in a college introduction SQL class and have recommended your video series to classmates as one of the best I have found. Thanks for your hard work.
i think you need to intially create table where the position of the column emplee_number stands after the job title. about the question 'How can you display the column employee_number in a specific position in the table when you run the code?' Answer: you need to create foreign key that references column employee_number from table employee with column salesman_employee_number from table customer
Thanks!
thank you!!!
you can do the same thing with inner join , correct???
thank you
Great
better than courser
Contents
Or statement
In statement
Sub query substitution
Thank you