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