Which of the following SQL query shall output names of all customers ending…

RPSC Programmer 2013

Which of the following SQL query shall output names of all customers ending with “Smith” ?

  1. A.

    Select name from customer where name like '_Smith'

  2. B.

    Select name from customer where name like '%Smith'

  3. C.

    Select name from customer where name like 'Smith%'

  4. D.

    Select name from customer where name like '%Smith%'

Attempted by 14 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…