专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > 报表

请问一个英文的数据库题

发布时间:2010-06-13 14:07:01 文章来源:www.iduyao.cn 采编人员:星星草
请教一个英文的数据库题
You need to analyze how long your orders to be shipped from the date that the order is placed. To do this you must create a report that displays the customer number, date order, date shipped and the number of months in whole numbers from the time the order is placed to the time the order is shipped. Which statement produces the required results? 
A. SELECT custid, orderate, shipdate, ROUND(MONTHS_BETWEEN(shipdate,orderate))
“Time Taken” FROM ord;
B. SELECT custid, orderate, shipdate,ROUND(DAYS_BETWEEN(shipdate,orderate))/30.
FROM ord;
C. SELECT custid, orderate, shipdate, ROUND OFF (shipdate-orderate) “Time Taken”
FROM ord;
D. SELECT custid, orderate, shipdate,MONTHS_BETWEEN (shipdate,orderate) “Time Taken”.
FROM ord;


------解决方案--------------------
A. SELECT custid, orderate, shipdate, ROUND(MONTHS_BETWEEN(shipdate,orderate)) “Time Taken” FROM ord;
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: