首页 > 试题广场 >

知识点:数据库 310(单选必答) Consider t

[不定项选择题]
知识点:数据库 3/10(单选/必答)
Consider the following schemaSTUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks);Which of the following query would display all the students where the second letter in the first name is ‘i’?
  • select first_name from students where first_name like ‘%i%’;
  • select first_name from students where first_name like ‘%i_’;
  • select first_name from students where first_name like ‘_i%’;
  • select first_name from students where first_name like ‘_i_’;

这道题你会答吗?花几分钟告诉大家答案吧!