Scenario: A developer needs to retrieve only specific records from a database table in a particular order. Which SQL clause should they use?
- WHERE
- ORDER BY
- GROUP BY
- HAVING
The correct option is 'ORDER BY'. This clause is used to sort the result set returned by the SELECT statement in either ascending or descending order based on one or more columns. It helps the developer to retrieve records in a specific order as required.
Loading...
Related Quiz
- Explain the concept of isolation levels in DB2 and their significance in concurrency control.
- What are some key features of IBM Data Studio that facilitate database administration tasks in DB2?
- What are some considerations for I/O optimization in DB2 performance tuning?
- How does the DEFERRABLE constraint affect the timing of constraint checking in DB2?
- The CHECK constraint in DB2 allows for ________.