Uncategorized

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;

Similar Posts