YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?()A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDE
题目
YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?()
A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESC
B.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limit
C.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLAST
D.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST
相似考题
参考答案和解析
参考答案：B, C