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 & solutions

The sorting and NULL values

Getting summarizing values

Aggregate function to aggregate function

Getting summarizing values