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
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.
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
Nice, very understandable.
Thanks again Joey Helping me so much with your vids
I really like your lecture. It is simple but easy to understand. You are the BEST, thanks!! :)
Awesome 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Very helpful! Thank you so much! Very straight forward and easy to follow and understand.
O thanks..this video was a life saver
Thanks a lot ,so helpful...
Thank you from South Korea
Very helpful for me, 10x
Thanks for sharing
Thank you so much
THANKS AGAIN SIR
it was really helpful thank you
easy and precise thanks buddy
Quick and informative
amazing explanation - thank you!
Character In the video It's great, I like it a lot $$
Thank you
Thanks!
thank you!!!
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
Great
better than courser
you can do the same thing with inner join , correct???
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.
Contents
Or statement
In statement
Sub query substitution
thank you