Felienne Hermans
Felienne Hermans
December 11th, 2021

Code Reading Club Reading Countdown - 11

Article cover photo

Countdown - Snippet 11

Today's code reading countdown in SQL.

Snippet

CRCRC-11

Snippet in text

-- 학생들 중 여학생들을 확인하는 쿼리문을 작성하세요.
select * 
from student 
where st_reg_num like '______-2%' or st_reg_num like '______-4%';

select * 
from student 
where st_reg_num like '%-2%' or st_reg_num like '%-4%';

Question

Explain these two queries in words, and the difference between them.

Submission

Submit your answer in our form.