Which SQL keyword is used to sort the result set in ascending order?
- ASC
- GROUP BY
- ORDER BY
- SORT
The ASC keyword is used in the ORDER BY clause to sort the result set in ascending order. It arranges the data in ascending order based on the specified column(s). Alternatively, you can use the keyword DESC to sort in descending order.
Loading...
Related Quiz
- When using connection pooling, the database connection remains open in a ___________ state.
- Scenario: You need to configure the connection pool for an application that requires multiple concurrent database connections. What factors should you consider while setting the connection pool parameters?
- The ___________ class is responsible for managing the database schema in LINQ to Entities.
- The DataAdapter's Update method is used to ___________ changes made to a dataset back to the database.
- In WinForms, which event is often used to trigger data binding updates?