COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Also
|
|
And
|
|
Or
|
|
Where
|
Detailed explanation-1: -You can use the AND condition in the WHERE clause to specify more than 1 condition that must be met for the record to be selected.
Detailed explanation-2: -The SQL AND & OR operators are used to combine multiple conditions to narrow data in an SQL statement. These two operators are called as the conjunctive operators. These operators provide a means to make multiple comparisons with different operators in the same SQL statement.
Detailed explanation-3: -You can use the AND and OR operators to combine two or more conditions into a compound condition. AND, OR, and a third operator, NOT, are logical operators.
Detailed explanation-4: -When two conditions must both be true for the rows to be selected, the conditions are separated by the SQL AND keyword. To refer to a set of values needed for a condition, use the SQL IN operator. To exclude one or more values using a condition, the SQL OUT keyword must be used.
Detailed explanation-5: -To select multiple values, you can use where clause with OR and IN operator.