+ 1

Can we use twice AND operator in single query?

29th Sep 2015, 6:59 PM
Sukriti Kumari Mishra
8 Answers
+ 3
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'
6th Oct 2015, 2:15 PM
Supreet - avatar
+ 2
You can use as many as you want in a query. Just make sure the format is right and use parentheses.
10th Mar 2016, 1:20 PM
Bijan Seyednasrollah
Bijan Seyednasrollah - avatar
+ 1
yes u can use as many as u need
16th Dec 2015, 9:19 AM
mahmoodreza roodafshani
mahmoodreza roodafshani - avatar
+ 1
16th Jul 2016, 8:19 PM
Dev_140897 - avatar
+ 1
yes we can
25th Jul 2016, 10:13 AM
Ahmed Babiker Abdalla
Ahmed Babiker Abdalla - avatar
+ 1
Yes. You can use, but more the no. of AND more the Performance degrade while Execution of Query.
13th Aug 2016, 8:06 PM
+ 1
24th Aug 2016, 11:23 PM
+ 1
Yes you can use
7th Jun 2018, 3:45 PM
Muhammad Sufyan