Different Query I Used
Hello! I used the 'IN' Clause is this best practice? Seems to be quicker. See below.
use employees;
select * from employees.employees where first_name in ('Kellie', 'Aruna');
1 answers ( 0 marked as helpful)
Hi Anthony!
Thanks for reaching out.
Yes, this code gives the same result set. It is doubtful whether the time is quicker because for such small result sets the time may be different. I tested both codes and the one with the OR operator was faster. Anyway, the query with the IN operator is shorter. Bravo!
Hope this helps.
Best,
Tsvetelin