PostgreSQL
Adding rows to a table with identity column
INSERT statement
CHAR and VARCHAR
Notes about data types
DATEADD function
T-SQL Datetime functions
Paging records
Window functions
Recursive CTE
Common table expressions (CTE)
The number-sequence generation
Typical problems
DATEDIFF function
T-SQL Datetime functions
Float(n)
Notes about data types
What do you need to work with the textbook?
Introduction
DATEPART function
T-SQL Datetime functions
Integer division
Notes about data types
Intersect and Except
Conventional set-theoretic operations and the SELECT statement
PostgreSQL CROSSTAB
PIVOT and UNPIVOT Operators
DELETE statement
Data modification statements
Renaming the columns and calculations in the result set
SELECT statement
Exercise #10 (tips and solutions)
Tips and solutions
The sorting and NULL values
Getting summarizing values
Aggregate function to aggregate function
Getting summarizing values