Multiple choice

Select the SQL statement which is used to find the employee city name starting with “mi”.

  1. Select * from tblemployee where city like ‘mi’

  2. Select * from tblemployee where city ‘mi%’

  3. Select * from tblemployee where city ‘‘mi%’’

  4. Select * from tblemployee where city like ‘mi%’

  5. Select * from tblemployee where city like ‘%mi’
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This option is correct because 'Select * from tblemployee where city like ‘mi%’ is the correct statement.

Keep practicing — related questions