Video description
- Sort data into groups and count the records in each group
- Compute max, min, and mean values for records in a group
- Format dates and numbers for display to end users
- Filter to eliminate unwanted groupings from your result set
- Search, concatenate, and manipulate strings
- Detect NULL values and replace them with real values
Table of contents
- Introduction 00:01:54
- Functions in a SELECT Statement 00:01:29
- Basic String Functions 00:08:57
- Date and Time Functions 00:03:21
- Conditional Functions 00:03:33
- The FORMAT Function 00:03:49
- Functions for NULL Values 00:06:00
- Aggregate Functions 00:03:34
- Aggregate Functions with NULL Values 00:06:34
- Processing Order of a SELECT Statement 00:02:24
- Grouping Results 00:04:25
- Filtering Grouped Results 00:02:28
Product information
- Title: Using T-SQL Functions and Summarizing Results
- Author(s):
- Release date: April 2019
- Publisher(s): Apress
- ISBN: 9781484245484
You might also like
video
Selecting Data from Multiple Tables
Extend your SELECT statements to retrieve data simultaneously from multiple tables in a SQL Server database. …
book
SQL Server 2017 Developer's Guide
Build smarter and efficient database application systems for your organization with SQL Server 2017 About This …
book
Beginning SQL Server Reporting Services
Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports …
book
SQL Server 2016 Reporting Services Cookbook
Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get …