单选题
“客户”表和“贷款”表的结构如下:
客户(客户号,姓名,出生日期,身份证号)
贷款(贷款编号,银行号,客户号,贷款金额,贷款性质)
在贷款表中,按贷款金额降序排列,将结果保存到名为temp.dbf的临时表中,应该使用的SQL语句是______。
- A.SELECT * FROM 贷款 INTO CURSOR temp ORDER BY 贷款金额 DESC
- B.SELECT * FROM 贷款 INTO TABLE temp ORDER BY 贷款金额 DESC
- C.SELECT * FROM 贷款 INTO FILE temp ORDER BY 贷款金额 DESC
- D.SELECT * FROM 贷款 TO FILE temp ORDER BY 贷款金额 DESC