Friday, June 19, 2020

Answer for Sometimes I would like to validate my results. How can I do this in this example (Exists-Not Exists)

https://365datascience.com/dwqa-answer/answer-for-sometimes-i-would-like-to-validate-my-results-how-can-i-do-this-in-this-example-exists-not-exists-2/ -

Hi Mike!

Thanks for your reply.

Do you think that the following query delivers the output you are aiming for? Thank you.


SELECT 
e.first_name, e.last_name, t.title
FROM
employees e
JOIN
titles t ON t.emp_no = e.emp_no
WHERE
title = 'Assistant Engineer';

Looking forward to your answer.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

No comments:

Post a Comment