SQL面试50题-46
46、查询各学生的年龄
知识点：DATEDIFF(datepart,startdate,enddate) (postgreSQL没有这个函数）
1. SELECT s_name,s_birth, DATEDIFF(month,s_birth,'2020-04-04')/12 FROM Student
2.
SELECT s_id,s_birth, (EXTRACT(YEAR FROM CURRENT_TIMESTAMP)-EXTRACT(YEAR FROM s_birth)) age FROM Student
查看20道真题和解析