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?
- A.
address LIKE '_INDIA_'
- B.
address = %INDIA%
- C.
address AS '%INDIA_'
- D.
address LIKE '%INDIA%'
Attempted by 464 students.
Sign up free to check your answer
Sign up freeLoading lesson…

