CASE
Paging records
Window functions
PIVOT operator
PIVOT and UNPIVOT Operators
WHERE clause
About the use of the operator CASE
GROUP BY clause
About the use of the operator CASE
Using NULL value in the search conditions
Predicates II
About the use of the operator CASE
Typical problems
HAVING clause
About the use of the operator CASE
UPDATE statement
Data modification statements
ORDER BY clause
About the use of the operator CASE
CASE statement
SELECT statement
Exercise #24
Computer Firm Database