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