网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
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

参考答案

更多 “ YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?() A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESCB.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitC.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLASTD.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST ” 相关考题
热门标签
最新试卷