What is the purpose of the GROUP BY clause in SQL queries?
- Aggregating data
- Filtering data
- Joining tables
- Sorting data
The purpose of the GROUP BY clause in SQL queries is to aggregate data based on specified columns. It is used in conjunction with aggregate functions such as COUNT, SUM, AVG, etc., to group rows that have the same values in specified columns. This allows for summarizing data and performing calculations on grouped data sets.
Loading...
Related Quiz
- FTP uses two separate ports: ___________ for data transfer and ___________ for control information.
- Explain the concept of a circular linked list and its advantages.
- The ________ layer of the OSI Model is concerned with establishing, maintaining, and terminating sessions between devices.
- Describe the working principle of demand paging in virtual memory management.
- What is the main drawback of the First Come First Serve (FCFS) scheduling algorithm?