0

Are these statements the same?

SELECT * FROM customers WHERE City = 'New York' OR City = 'Los Angeles' OR City = 'Chicago'; =============================== SELECT * FROM customers WHERE City = 'New York' AND City = 'Los Angeles' AND City = 'Chicago';

8th Oct 2016, 6:13 PM
Nabeel Ishaq Bashir
Nabeel Ishaq Bashir - avatar
2 Antworten
+ 1
nope...these are not same logical operator
10th Oct 2016, 6:08 PM
Faridul Hasan
Faridul Hasan - avatar
0
and operator and the or operator. they are different
12th Jan 2017, 8:01 PM
Hakkı Karahan
Hakkı Karahan - avatar