Order by为()。
第1题:
按照姓名升序序排列( )
A.ORDER BY NAME ASC
B.ORDER BY ASC NAME
C.ORDER BY NAME DESC
D.ORDER BY DESC NAME
第2题:
A.SELECTROUND(order_date,’day’)FROMinventory
B.SELECTROUND(order_date,’YEAR’)FROMinventory
C.SELECTROUND(order_date,’month’)FROMinventory
D.SELECTROUND(to_char(order_date,’yyyy’))FROMinventory
第3题:
设有订单表order(其中包含字段:订单号,客户号,职员号,签订日期,金额),查询2007年所签订单的信息,并按金额降序排序,正确的SQL命令是( )。
A.SELECT * FROM order WHERE YEAR(签订日期)=2007 ORDER BY 金额 DESC
B.SELECT * FROM order WHILE YEAR(签订日期)=2007 ORDER BY 金额 ASC
C.SELECT * FROM order WHERE YEAR(签订日期)=2007 ORDER BY 金额 ASC
D.SELECT * FROM order WHILE YEAR(签订日期)=2007 ORDER BY 金额 DESC
第4题:
在GZ表中选出职称为“工程师”的记录,并按年龄的降序排列,则实现的SQL语句为()
ASELECT FROM GZ for 职称=工程师 ORDER BY 年龄/D
BSELECT FROM GZ WHERE职称=工程师 ORDER BY 年龄 DESC
CSELECT * FROM GZ WHERE职称=‟工程师‟ ORDER BY 年龄 DESC
DSELECT * FROM GZ WHERE职称=‟工程师‟ ORDER ON 年龄 DESC
第5题:
将结构索引文件中的“图书号”设置为当前索引,使用的命令是( )。
A.SET ORDER TO TAG图书号
B.CREATE ORDER TO图书号
C.SET INDEX TO图书号
D.ORDER TO TAG图书号
第6题:
A.in order to
B.in order for
C.in order that
第7题:
The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? ()
A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;
第8题:
按照姓名降序排列( )
A.ORDER BY DESC NAME
B.ORDER BY NAME DESC
C.ORDER BY NAME ASC
D.ORDER BY ASC NAME
第9题:
A.onlythelow-order23bitsoftheMACaddressareusedtomapIPaddresses
B.onlythelow-order24bitsoftheMACaddressareusedtomapIPaddresses
C.onlythehigh-order23bitsoftheMACaddressareusedtomapIPaddresses
D.onlythelow-order23bitsoftheIPaddressareusedtomapMACaddresses
E.the0x01004fMACaddressprefixisusedformappingIPaddressestoMACaddresses
F.the0x01005eMACaddressprefixisusedformappingIPaddressestoMACaddresses
第10题:
Order by为()语句。