Multiple choice

SELECT ename FROM emp WHERE ename LIKE '%A_E%'; Which name from the following names can selected by the above query?

  1. SALEA

  2. ALISHE

  3. SASLEA

  4. Options 2 and 3

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

It will find any string that contains the letter 'A' followed by any single character followed by the letter 'E'. And in between the name there is a ALE form.

Keep practicing — related questions