Question

MySQL 里面 SELECT的问题。

Display the last name of all employees, along with their age. Order the result in the descendingsequence of age. (A not very good expression to calculate age is in the lecture slides – can youdo better? HINT: Look up the TIMESTAMPDIFF command.)
怎样用TIMESTAMPDIFF罗列出他们的年龄啊 ？求教！！

Answer 1

select lastname, timestampdiff(year,birthdate,now()) as age from table order by age desc