Last answered:

10 Jul 2023

Posted on:

08 Jul 2023


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)
Posted on:

10 Jul 2023


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.

Submit an answer