查询学生的姓名,系别和年龄,显示时按系别降序排列,系别相同的再按年龄升序排列。( )
选项:
A:select sname, sdept, sage from student order by sdept desc , sage;
B:select * from student order by sdept , sage;
C:select sname, sdept, sage from student order by sdept , sage;
D:select * from student order by sdept desc, sage
发布时间:2024-05-07 19:16:16