loading..
Русский    English
23:33

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
Развернуть всё
Свернуть всё

Content:

Tags
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 CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates EXCEPT exercise (-2) exercise 19 exercise 23 exercise 32 More tags
The book was updated
several days ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.
Rambler's Top100