皮皮学，免费搜题
登录
搜题
【单选题】
有订单表Orders,它的数据如下图所示。列出客户订单总金额大于3000的数据,正确的是()A.
SELECT ID,SUM(OrderAmount) FROM ORDERS group by ID having sum(OrderAmount)>3000
B.
SELECT ID,SUM(OrderAmount) FROM ORDERS where sum(OrderAmount)>3000 group by ID
C.
SELECT ID,SUM(OrderAmount) FROM ORDERS where sum(OrderAmount)>3000
D.
SELECT ID,SUM(OrderAmount) FROM ORDERS group by ID where sum(OrderAmount)>3000
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【单选题】Webster & Moore paid $148,000, in cash, for a piece of equipment 3 years ago. At the beginning of last year, the company spent $21,000 to update the equipment with the latest technology. The company n...
A.
0
B.
21000
C.
96000
D.
110000
E.
160000
【简答题】Thank you for your purchase of out Buick( 别克 ) car at Shanghai GM( 上海通用汽车公司 ). We try our best to provide you with world-class service. To betterensure your rights, please complete and return the Owne...
【单选题】据载，清政府的官员都不知道俄国人要求的领土有多大，兴安岭离乌苏里江有多远，还有哪些内容在《尼布楚条约》中尚未确定。材料中“俄国人要求的领土”位于我国
A.
东北
B.
西北
C.
东南
D.
西南(2016广东省中考历史试题及答案)
【单选题】In its latest research effort, the X-Cel Corporation requires subjects to “place themselves in place of another person” and explain the reasons for their purchase behavior. The firm is employing a for...
A.
protocol technique
B.
depth interviews
C.
experience survey
D.
word association technique
E.
projective technique
【单选题】据载,清政府的官员都不知道俄国人要求的领土有多大,兴安岭离乌苏里江有多远,还有哪些内容在《尼布楚条约》中尚未确定。材料中 “俄国人要求的领土”位于我国
A.
东北
B.
西北
C.
东南
D.
西南
【单选题】In its latest research effort, the X-Cel Corporation requires subjects to “place themselves in place of another person” and explain the reasons for their purchase behavior. The firm is employing a for...
A.
protocol technique.
B.
in-depth technique.
C.
experience technique.
D.
word association technique.
E.
projective technique.
【简答题】Thank you for your purchase of our Buick (别克) car at Shanghai GM (上海通用汽车公司).We try our best to provide you with world-class service. To better ensure your rights, please complete and return the Owner ...
【简答题】西汉时期将边疆地区新设立的郡叫做()。
相关题目：
参考解析：
知识点：
题目纠错 0
发布
