SELECT SQL Question

[TSO456]

Hello,

I have the following table. How can I select the clients that have 100 employees and are in prodcut X or Prodcut Y

Client # EMPLOYEES Prodcut

A 100 X
B 200 Y
C 100 X
D 50 Y
E 25 X

Thank You

 

[Jerrycurl]

SELECT client FROM client_table
WHERE num_employees = 100 AND
prodcut in ('X','Y')

 

[link9]

by "in" you mean that prodCut is either x or y -- is that right? And when you say have 100 employees, do you mean exactly 100 or 100 or more?

If you mean exactly 100, then you can say:

SELECT client FROM client_table
WHERE num_employees = 100 AND
prodcut = 'X' OR prodCut = 'Y'

and if you mean 100 or more, then you can ask:

SELECT client FROM client_table
WHERE num_employees >= 100 AND
prodcut = 'X' OR prodCut = 'Y'