Winch two queries would achieve the required result?

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. Winch two queries would achieve the required result? (Choose two.)

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. Winch two queries would achieve the required result? (Choose two.)

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 NULLS LAST:

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *