4:38
Section 06: Create aggration in a query
Course: This course is created for business people or data analysts who want to query data from an SQL Server database but don't want to write codes and queries in SQL language. This course teach you how to use GUI of SQL Server Management Studio Query Designer Tool.
Course: This course is created for business people or data analysts who want to query data from an SQL Server database but don't want to write codes and queries in SQL language. This course teach you how to use GUI of SQL Server Management Studio Query Designer Tool.
Video Steps
01. 00:00 Create aggregated query
Arrange tables on Diagram pane and add aggregation02. 00:30 Define criteria
Define filter criteria in Criteria pane03. 01:20 Duplications
Understand duplication in a query04. 01:20 Aggregation
Learn how to convert a query to an aggregation query05. 02:45 Simple aggregation
Create a simple count aggregation and analyze it06. 03:35 Subquery
Understand the role and needs of a subquery
1 Comment
Jump to next section:Query data with no SQL code (7) - 7. Create a subquery
Jump to prev section:Query data with no SQL code (5) - 5. Usage of Criteria Pane of Query Designer
Jump to prev section:Query data with no SQL code (5) - 5. Usage of Criteria Pane of Query Designer
Suggested Videos
In this article, we will see the options and faster ways to load large tables in Oracle database.
In this article, we'll take a closer look at JSON in Oracle SQL and how you can use it in your applications.
