Multiple choice

The and operator is written as __ in SQL.

  1. &&

  2. and

  3. &

  4. *
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL to combine 2 or more condition in a statement, we can use the logical operators like - and & or. The or operator joins 2 or more conditions are return those records that satisfy any of the given conditions. The and operator is used to display those records that satisfy all the given conditions. For example to see the records of a table named students that have a percentage between 50 and 60 the following SQL can be usedselect * from students where percentage>50 and percentage<60.< em=""> 60.<>

Keep practicing — related questions