How to club AND and ORs together of a where query?

SQL++
1

Let me give an example
Select * FROM product WHERE type = “123” AND category = “healthcare” OR category = “retail”
how to ensure all the category conditions are evaluated first?

Ramesh

2

Qualify with precedence (i.e. ()).

Select * 
FROM product 
WHERE  ((category = "healthcare" OR category = "retail") AND   type = "123" )
3

Thank you very much :slight_smile: