sql,学生表(student),id,name ,age ,求前10个年龄最大的

sqlserver::

select  top 10 * from student  order by age desc  

mysql:

select * from student  order by age desc limit 10

 

posted on 2021-03-06 18:13  jesse_zhao  阅读(852)  评论(0编辑  收藏  举报

导航