Tag Archives: cust_last_name

Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id

Examine this SQL statement:SELECT cust_id, cust_last_name “Last Name”FROM customersWHERE country_id = 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = 30Identify three ORDER BY clauses, any one of which can complete the query successfully.(Choose three.) A. ORDER BY 2, cust_id B. ORDER BY “CUST_NO” C. ORDER BY “Last Name” D. ORDER BY 2, 1 E. ORDER BY CUST_NO Correct Answer:… Read More »

Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id

Examine this SQL statement:SELECT cust_id, cust_last_name “Last Name”FROM customersWHERE country_id = 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = 30Identify three ORDER BY clauses, any one of which can complete the query successfully.(Choose three.) A. ORDER BY “Last Name” B. ORDER BY CUST_NO C. ORDER BY “CUST_NO” D. ORDER BY 2, 1 E. ORDER BY 2, cust_id Correct Answer:… Read More »