MJpipi - 2006-8-16 0:37:00
请问以下两段程序有什么区别?
creat view view_ca as;
SELECT Employee.职工号, Employee.姓名,;
YEAR(DATE())-YEAR(Employee.工作日期) AS 年龄;
FROM orders_manage!employee;
ORDER BY 3 DESC
creat view view_ca;
as select employee.职工号,姓名,year(date())-year(出生日期) as 年龄 from orders_manage!employee order by 3 desc
© 2000 - 2024 Rising Corp. Ltd.