can we use multiple conditions in single WHERE. ..?

Question

SELECT * FROM customers
WHERE id>= 2 AND id <=8 , Age >= 35 AND Age<=40 ;

Answer 1

yes you can, but they need to be separated by a logical operator ( ie OR, AND ...) also be careful with the order of the conditions using brackets to nest properly

Answer 2

Yes , You can get multiple condition using seperator by boolean operators like AND , OR , NOT.

Answer 3

yes, you just need to be aware of how your conditionals are grouped. you would want your where statement to look more like one of these
...
WHERE (id BETWEEN 2 AND 8) AND (Age BETWEEN 35 AND 40) --if your database is configured to include the outer values in the result set

WHERE (id >= 2 AND id <= 8) AND (Age >= 35 AND Age <= 40) -- if your database will not include the outer values of a between statement in the result set or you aren't sure whether it does

Answer 4

yes

Answer 5

Yes you can use

Answer 6

yes

Answer 7

yes ofcourse

Answer 8

yes

Answer 9

Yes

Answer 10

yes.

Answer 11

yes

Answer 12

yes

Answer 13

yes

Answer 14

yeah

Answer 15

yeah ... obviously

Answer 16

sure

Answer 17

yes by using And, Or & Not.

Answer 18

Yes

Answer 19

yes u can

Answer 20

yes