以下是产品(PRODUCT)表中的数据:
PRODUCT |
ID NUMBER | DESCRIPTION | MANUFACTURER ID | QUANTITY | COST |
215 | AAA 6pk-battery | NF10032 | 546 | 3.00 |
140 | AA 2pk-battery | EL7968 | 2000 | |
603 | D 2pk-battery | OT456 | 318 | 1.10 |
725 | C 2pk-battery | OT456 | 239 | .75 |
218 | AAA 6pk-battery | OT456 | 980 | 3.25 |
220 | AAA 8pk-battery | NF10032 | | 4.20 |
126 | AA 2pk-battery | NF10032 | 2513 | |
751 | C 2pk-battery | EL7968 | 84 | 100 |
SELECT description, quantity, cost
FROMproduct
WHERE manufacturer_id LIKE ’NF10032’
AND
NVL(cost, 0)<5.00
ORDER BY quantity DESC, cost;
以上的查询语句将产生如下的哪个结果A.DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AA 2pk-battery
2513
AAA 6pk-battery
546
3
B.DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AAA 8pk-battery
4.2
AA 2pk-battery
2513
AAA 6pk-battery
546
3
C.DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AAA 6pk-battery
546
3
AAA 8pk-battery
4.2
AA 2pk-battery
2513
D.DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AA 2pk-battery
2513
AAA 6pk-battery
546
3
AAA 8pk-battery
4.2