Online Course Support

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

Similar Posts