Jump to Content

Java C#/.NET C++SQL*Integrations Ignite for Spark Tools

Java C#/.NET C++SQL*Integrations Ignite for Spark Tools Log In Examples Ask a Question

Guides

Log In Examples Ask a Question

CASEWHEN

Introduction

Overview
Getting Started

SQL Reference

SQL Reference Overview
SQL Conformance
Data Definition Language (DDL)
Data Manipulation Language (DML)
Operational Commands
Aggregate Functions
System Functions
Transactions
Data Types
Date and Time Functions
String Functions
Numeric Functions
- COMPRESS
- BITGET
- COT
- BITOR
- RAND
- LOG10
- BITAND
- ROUND
- RANDOM_UUID
- ACOS
- POWER
- EXPAND
- ATAN
- EXP
- MOD
- BITXOR
- SIN
- RADIANS
- TANH
- SIGN
- SINH
- COSH
- SQRT
- LOG
- CEILING
- ENCRYPT
- TRUNCATE
- ROUNDMAGIC
- ABS
- FLOOR
- ZERO
- DEGREES
- DECRYPT
- PI
- TAN
- ASIN
- SECURE_RAND
- ATAN2
- COS

Architecture

Geospatial Support
Local Queries
Schemas
Distributed Joins
Performance and Debugging
SQL Transactions
How Ignite SQL Works

SQL and Key-Value

SQL and Key-Value Usage

JDBC

JDBC Client Driver
JDBC Driver
Error Codes

ODBC

Querying and Modifying Data
Specification
Data Types
ODBC Driver
Connection String and DSN
Error Codes

Management and Monitoring

JDBC/ODBC Session Management

Tools and Analytics

SQLLine
Pentaho
SQL Tooling
Tableau
Apache Zeppelin

PHP Developer Guide

PHP PDO

Java Developer Guide

Schema and Indexes
Query Cancellation
SQL API
Custom SQL Functions

.NET Developer Guide

LINQ
SQL API
Schema and Indexes

LEGAL

Apache License
Copyright

C++ Developer Guide

Schema and Indexes
SQL API

Powered by

CASEWHEN

CASEWHEN (boolean , aValue , bValue)

Description

Returns 'aValue' if the boolean expression is true, otherwise 'bValue'.

Examples

CASEWHEN(ID=1, 'A', 'B')

Updated almost 5 years ago

Table of Contents
- Description
- Examples