SQL面试50题-31
31、查询1990年出生的学生名单(重点year)
1.
SELECT * FROM Student WHERE s_birth LIKE '1990%'
2.
SELECT * FROM Student WHERE YEAR(s_birth) = 1990
31、查询1990年出生的学生名单(重点year)
1.
SELECT * FROM Student WHERE s_birth LIKE '1990%'
2.
SELECT * FROM Student WHERE YEAR(s_birth) = 1990
相关推荐