试题详情
多项选择题You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）

A、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC

B、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit

C、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST

D、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST

  • B,C

  • 关注下方微信公众号，在线模考后查看

热门试题