单选题
Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 100 12-JAN-2000 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 104 25-JUN-2000 15 6000 105 18-JUL-2000 20 5000 106 18-JUL-2000 35 7000 107 21-JUL-2000 20 6500 04-AUG- 108 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Linda New York Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）
发布日期：2020-04-10
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');
SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'MARTIN'));
SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');
SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
下列哪项不是猪苓汤的主症（）
疟疾预防措施除外（）
关于胎头径线以下说法错误的是（）
支取方式为“不验印不验密”的对公账户，在发起贷记往账时需（）。
住院登记是住院患者信息采集的第一个步骤，它关系到住院患者的（）
在运输市场中，运单即是运输合同。
关于DWI上组织信号强度衰减的描述中，正确的是（）
依次填入下列各句横线处的词语，恰当的一组是（ ）。（1）这所古老的建筑正当路口，______交通。要不要拆除，有关部门正在研究。（2）这种树的表皮可以一层层剥下来，做成精致的小盒子，并不______它的生长。（3）还有难于计算的尘埃和气体组成的星云，浮游在星星与星星之间，浮游在宇宙空间里，______星光的通过。
生殖器疱疹感染孕妇娩出的新生儿可能发生（）
与“欲穷千里目，更上一层楼”有异曲同工之妙的诗句是（ ）。
暂无相关推荐~
Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statemen...
Examine the data from the ORDERS and CUSTOMERS table. Which SQL statement retrie...
Examine the data from the ORDERS and CUSTOMERS tables. ORDERS ORD_ID ORD_DATE CU...
Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUS...
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_N...
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO...
View the Exhibit and examine the structure of the ORDERS table. Which task would...
Examine the SQL statements that creates ORDERS table: For which columns would an...
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO...
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. ...