Multiple choice

Which query among following can give more than one name (employee name or ename)?

  1. SELECT ename WHERE ename AMONG ('value1', 'value2','value3', ...)

  2. SELECT ename WHERE ename = ('value1', 'value2','value3', ...)

  3. SELECT ename WHERE ename IN ('value1', 'value2','value3', ...)

  4. SELECT ename WHERE ename WITH ('value1', 'value2','value3', ...)

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

IN will find any value existing in a set of candidates.

Keep practicing — related questions