Database--Querying the database how to take the year from date of birth

Year (birthday), get years
Month (birthday), get monthly
Day (birthday), get
The premise is that this birthday is a date Type field.

The Sno, sname and Sbirthday of all the students who were born in the same year were queried and studied for the student number 108.

Select Sno,sname,sbirthday from Student where sbirthday= (select Sbirthday from Student where sno= ' 108 ') #年月日全部匹配

Select Sno,sname,sbirthday from Student where year (sbirthday) = (select year (sbirthday) from Student where sno= ' 108 ') #只匹配年

Database--Querying the database how to take the year from date of birth