+ 3

is OR and IN same?

8th Feb 2016, 1:32 PM
Chirag Ramkrushna Bharambe
Chirag Ramkrushna Bharambe - avatar
7 Answers
+ 4
nooo dear or is used in the case where there is given some condition for choosing whereas in is used to print data or tables where we need a thing like the questions write a query to show the no of students in class 11 from a predefined student table . so I think now it is clear 2 u
27th Dec 2016, 10:31 AM
SAGAR SINGHA ROY
SAGAR SINGHA ROY - avatar
+ 2
yes. same. But its better use IN as we can do it in single statement....
2nd Apr 2016, 5:16 AM
Kishor Tiwari
Kishor Tiwari - avatar
+ 2
Yes they are same. But if you have so many values to compare just use IN.
27th Dec 2016, 8:58 AM
Raniket Ram
Raniket Ram - avatar
+ 1
if there are two values to be compared then use or else use in beside this in is also used to copy a table in other database in is bigger brother we can use in in place of or anywhere but with 2 values syntax will look like waste
14th Jul 2016, 7:38 PM
manish rawat
manish rawat - avatar
+ 1
No they are not the same. Or gives you the results of either/or but in gives you the within / range...
22nd Jan 2017, 5:25 PM
Devraj Giri
0
Rahul savita
27th Jan 2017, 1:12 PM
Abhi Kumar
Abhi Kumar - avatar
- 4
nanXCZNJHE*
12th Jul 2016, 4:52 AM
Talia Merom
Talia Merom - avatar