Which operation is used for summarization in SQL?
- DELETE
- INSERT
- SELECT
- UPDATE
The SELECT operation in SQL is used for summarization. It allows you to retrieve and present summarized information from the database. By using aggregate functions like SUM, AVG, MAX, MIN, or COUNT in conjunction with the SELECT statement, you can perform summarization operations on the data stored in tables.
Loading...
Related Quiz
- In which normal form are all non-key attributes fully functionally dependent on the primary key, and no transitive dependencies exist?
- Forward Engineering typically involves the creation of _______ scripts to generate a database schema from a conceptual model.
- How does data partitioning contribute to database performance?
- Scenario: An online store has various types of products, including electronics and clothing. Each product has common attributes like name and price, but they also have specific attributes. How would you design the database schema for this scenario?
- The structure of data in a column-family store allows for efficient _______.