问题

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 queri

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

参考答案

您可能感兴趣的试题

In which of the areas listed would you expect to find the highest salt concentration in a

答案解析
What solution does Divya Bhargavi offer？A．Making a list of what you really want to buy.B．N

答案解析
______of milk is left in the refrigerator. You need to buy______from the supermarket.A．Som

答案解析
Speaker A: What are you searching for？ Speaker B: ______I need to get out of here.A．I"m lo

答案解析
Its better to call for help if you need to get out of bed while the medicine is__

答案解析
You have a WINS server that runs Windows Server 2003 Service Pack 2 (SP2).You need to schedule a backup of the WINS database whenever the WINS service stops.What should you do? ()

答案解析