Multiple choice

Select a query to display the name of employees whose name ends with 'S' .

Consider the following relation schema:
 EMP(ENAME,EMPNO,SAL,COMM,DEPTNO,JOB,MGR,HIREDATE);

  1. select ENAME from EMP where ENAME like '%S' ;

  2. select ENAME from EMP where ENAME like '%%S' ;

  3. select ENAME from EMP where ENAME like 'S' ;

  4. select ENAME from EMP where ENAME like '%S%' ;

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

It will fetch the correct data.

Keep practicing — related questions