The zip column (type INT) in the california_offices table has values from 90001 to 95899. The zip column (also type INT) in the oregon_offices table has values from 97030 to 97440. Which value is guaranteed to be in the top row of the result set when you run the following query with Impala?
Question 4
The zip column (type INT) in the california_offices table has values from 90001 to 95899. The zip column (also type INT) in the oregon_offices table has values from 97030 to 97440. Which value is guaranteed to be in the top row of the result set when you run the following query with Impala?
SELECT zip FROM california_offices
UNION ALL
SELECT zip FROM oregon_offices
ORDER BY country DESC;
1 point
90001
95899
97030
97440
No particular value is guaranteed to be in the top row