itgle.com

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