针对学生表student(sno,sname,ssex,sage,sdept),其中sno为学号,sname为姓名,ssex为性别,sage为年龄,sdept为系别。查询学生的姓名sname,系别sdept和年龄sage,显示时按系别升序排列,系别相同的再按年龄降序排列。( )
选项:
A: select sname, sdept, sage from student order by sdept , sage desc;;
B: select * 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