Consider the following SQL query to retrieve ecode of employees from EMPLOYEE…

HTET 2019

Consider the following SQL query to retrieve ecode of employees from EMPLOYEE table, whose address contains 'INDIA':

SELECT ecode
FROM EMPLOYEE
WHERE ……. ;

Which of the following is most suitable to complete the query?

  1. A.

    address LIKE '_INDIA_'

  2. B.

    address = %INDIA%

  3. C.

    address AS '%INDIA_'

  4. D.

    address LIKE '%INDIA%'

Attempted by 464 students.

Sign up free to check your answer

Sign up free

Explore the full course: Bpsc

Loading lesson…