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

PYQ RPSC Programmer 2013 Paper I

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: Btsc Lab Assistant

Loading lesson…