The SQL ____________ clause is used to specify the order in which data should be retrieved, potentially impacting query performance.

  • ORDER BY
  • GROUP BY
  • WHERE
  • HAVING
The correct option is ORDER BY. This clause is used in SQL queries to sort the result set based on specified columns either in ascending or descending order. It's crucial for performance optimization as it influences how data is fetched from the database.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *