About the use of the operator CASE

	Prepare for the second stage of testing Typical problems About the use of the operator CASE
	Chapter 5 (item 5.10) describes syntax of this operator, and examples of its use are presented. However these examples show the usage of CASE only in SELECT clause. Really, this place of the most frequent use of the operator, however not the only thing. We can apply CASE practically everywhere where scalar value is expected Here we again give some examples of its usage in other clauses of SELECT statement. Content: (8.3.1.) WHERE clause (8.3.2.) GROUP BY clause (8.3.3.) ORDER BY clause CASE

Last added:

Tags

aggregate functions ALL ASCII AVG Battles Bezhaev Bismarck C.J.Date Cartesian product CASE cast CHAR CHARINDEX classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CTE data type conversion database schema DATEDIFF DATEPART DATETIME DELETE DISTINCT duplicates EXCEPT exercise (-2) exercise 19 exercise 23 exercise 32 exercise 37 exercise 39 exercise 46 exercise 54 exercise 55 exercise 56 exercise 57 exercise 7 exercise 70 exercise 8 exercises EXISTS FROM FULL JOIN GROUP BY More tags

The book was updated
several days ago

SQL Problems and solutions