How to build a SQL statement using Different conditions like where condition and how to declare the data types?

Answer 1

Select * from table where colA = ? and colB = ?
Like that ?

Answer 2

thanks more examples

Answer 3

can we use 'comma' rather than and?

Answer 4

No in mysql/mariadb idk about the others rdbms

Answer 5

in oracle rdbms can we use comma?

Answer 6

No, we cant