Can we use twice AND operator in single query?

Answer 1

yes
for example
SELECT name , account_type FROM banks WHERE name LIKE A% AND (account_type='saving' AND account_type='current');

here above is a query against the names for customers having both type of account with the banks.

and sorry its not explained here about "Like A%"
so when I write "name like A%" it represents all names starting from Capital( Uppercase ) alphabet 'A'

Answer 2

You can use as many as you want in a query. Just make sure the format is right and use parentheses.

Answer 3

yes u can use as many as u need

Answer 4

yes

Answer 5

yes we can

Answer 6

Yes. You can use, but more the no. of AND more the Performance degrade while Execution of Query.

Answer 7

Yes

Answer 8

Yes you can use