Multiple choice

All the values in 'where in' clause must be separated by a _____.

  1. colon (:)

  2. period (.)

  3. comma (,)

  4. space

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Comma is the valid separator in an in clause. The in keyword is used with where to provide a list of values to select. For example, to select all those records where the value in column sport is either Cricket or Football, the statement will select * from players where sport in ('Cricket','Football') The above statement will separate all the rows where the value of the column sport is Cricket or Football.