SQL 视图：显示年龄小于 20 岁的学生信息

CREATE VIEW x_view AS SELECT sno, sname, s_bir, email FROM student WHERE YEAR(CURDATE()) - YEAR(s_bir) < 20;

原文地址: https://www.cveoy.top/t/topic/nWuD 著作权归作者所有。请勿转载和采集!