Русский    English

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.

Bookmark and Share
Развернуть всё
Свернуть всё


aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONSTRAINT CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema DATEADD DATEDIFF DATENAME DATEPART DATETIME date_time functions DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates edge equi-join EXCEPT exercise (-2) More tags
The book was updated
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.