SQL语言中用于表示排序的关键字是()。
A.where by
B.order by
C.group by
D.having by
- · 有5位网友选择 A,占比50%
- · 有3位网友选择 D,占比30%
- · 有1位网友选择 C,占比10%
- · 有1位网友选择 B,占比10%
A.where by
B.order by
C.group by
D.having by
B.getc char printf
C.include scanf case
D.while go pow
A、SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) DESC
B、SELECT DNO,SUM() as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) ASC
C、SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) ASC
D、SELECT DNO,SUM() as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) DESC
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!