113.Examine the structure of the ORDERS table:
来源:互联网 发布:science direct数据库 编辑:程序博客网 时间:2024/06/05 16:15
113.Examine the structure of the ORDERS table:
Name Null Type
ORDER_ID NOT NULL NUMBER(12)
ORDER_DATE NOT NULL TIMESTAMP(6)
CUSTOMER_ID NOT NULL NUMBER(6)
ORDER_STATUS NUMBER(2)
ORDER_TOTAL NUMBER(8,2)
You want to find the total value of all the orders for each year and issue the following command:
SQL>SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date,'yyyy');
Which statement is true regarding the outcome?
A.It executes successfully and gives the correct output.
B.It gives an error because the TO_CHAR function is not valid.
C.It executes successfully but does not give the correct output.
D.It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.
答案:D
解析:group by中是啥,显示的字段就是啥,包括格式
Name Null Type
ORDER_ID NOT NULL NUMBER(12)
ORDER_DATE NOT NULL TIMESTAMP(6)
CUSTOMER_ID NOT NULL NUMBER(6)
ORDER_STATUS NUMBER(2)
ORDER_TOTAL NUMBER(8,2)
You want to find the total value of all the orders for each year and issue the following command:
SQL>SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date,'yyyy');
Which statement is true regarding the outcome?
A.It executes successfully and gives the correct output.
B.It gives an error because the TO_CHAR function is not valid.
C.It executes successfully but does not give the correct output.
D.It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.
答案:D
解析:group by中是啥,显示的字段就是啥,包括格式
0 0
- 113.Examine the structure of the ORDERS table:
- 94.Examine the structure of the PROGRAMS table:
- 6.Examine the structure of the SHIPMENTS table:
- 18.Examine the structure of the PROMOTIONS table:
- 86.Examine the structure and data of the CUST_TRANS table:
- 96.Examine the structure of the INVOICE table.
- 102.Examine the structure of the TRANSACTIONS table:
- 103.Examine the structure of the TRANSACTIONS table:
- 104.Examine the structure of the PROMOS table:
- 105.Examine the structure of the PROMOS table:
- 109.Examine the structure of the MARKS table:
- 125.Examine the structure of the CUSTOMERS table:
- 140.Examine the structure of the PRODUCTS table:
- 157.View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.
- 160.View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 10.View the Exhibit;examine the structure of the PROMOTIONS table.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- spyder使用教程
- JS中的!=、== 、!==、===的用法和区别。
- Error:(1, 0) Plugin is too old, please update to a more recent version, or set ANDROID_DAILY_OVERRID
- PAT_Basic 1014
- 动态规划-数字三角形
- 113.Examine the structure of the ORDERS table:
- RecyclerView实现下拉刷新和上拉加载更多
- logstash+es+kibana+redis搭建
- [Ubuntu]Linux kernel degrade
- 两个Integer ==和!=的比较,为什么失效?
- CentOS安装rar、unrar解压缩软件的方法
- PostgreSQL学习手册(常用数据类型)
- 使用命令给APK进行签名
- Java面试知识学习笔记1(2016/3/7)