题解 | #纠错4#
纠错4
https://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
解答:因为union 在连接2个select指令后其实只能算一张表,一张表的情况下无法进行2次order by,且表格都是最后进行排序的,所以应该把第一个order by删掉。
SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'IL' ORDER BY cust_name;