Question

要查询表worker中年龄最大和最小的所有员工信息,用SQL语句怎样写?

Answer 1

select top 1 * from worker order by age;(最小)
select top 1 * from worker order by age desc;(最大)

Answer 2

select *
from T_users
where U_age=(select max(U_age) from T_users)