Select the queries that will return exactly the same result as the query: SELECT * FROM fly.planes ORDER BY year DESC; when executed by Impala. Check all that apply.
Question 5
Select the queries that will return exactly the same result as the query:
SELECT * FROM fly.planes ORDER BY year DESC;
when executed by Impala. Check all that apply.
1 point
- SELECT * FROM fly.planes ORDER BY year ASC;
- SELECT * FROM fly.planes ORDER BY year ASC NULLS FIRST;
- SELECT * FROM fly.planes ORDER BY year NULLS FIRST;
- SELECT * FROM fly.planes ORDER BY year ASC NULLS LAST;
- SELECT * FROM fly.planes ORDER BY year;
- SELECT * FROM fly.planes ORDER BY year DESC NULLS LAST;
- SELECT * FROM fly.planes ORDER BY year NULLS LAST;
- SELECT * FROM fly.planes ORDER BY year DESC NULLS FIRST;