Teradata String Function

Teradata supports several string functions to manipulate the string. UPPER & LOWER Function The UPPER and LOWER functions covert the character column values all in uppercase and lowercase respectively. UPPER and LOWER are ANSI compliant. Syntax UPPER ( expression ) … Read more »

Teradata Aggregate Function

The Aggregate functions prepare the summarization of values from one or more tables. Detail level of information will be lost after performing the aggregate on some specific tables. Teradata support most common Aggregate function as below. Function Name Detail COUNT … Read more »

COALESCE in Teradata with example

COALESCE in Teradata is used for NULL handling. The COALESCE returns the first NOT NULL value encountered in the provided list. Otherwise it returns NULL if all the arguments in the expression list evaluate to NULL.    COALESCE Function Syntax  The … Read more »

CASE and COALESCE Statement in Teradata

CASE Statement in Teradata Teradata CASE statement provides the flexibility to fetch alternate values for a column base on the condition specified in the expression.  Not getting? Ok, let me explain with a simple example.   Teradata CASE Statement Example … Read more »

Teradata Count Distinct

The count function returns the total number of qualified rows in the value expression. Teradata count distinct returns the total number of distinct rows. Teradata Count Distinct Syntax COUNT ( [TYPE] value_expression ); Here, value_expression – A literal or column … Read more »

Describe Table in Teradata

DESCRIBE TABLE shows the columns related information in most of the popular RDBMS like ORACLE, MySQL, etc. There is no Describe Table command available in Teradata. Teradata provides two alternative ways to view the columns related information. They are as below. … Read more »

LIKE in Teradata

Teradata LIKE operator is used for pattern matching in the specified column. This is used in the WHERE clause and may use wildcard characters and special characters to match a pattern from a word. Teradata LIKE operator is can be … Read more »

BETWEEN in Teradata

The BETWEEN operator in Teradata selects a range of data between two values. This is generally used with the WHERE clause to filter out the data in the result-set.  Teradata BETWEEN Syntax Following is the syntax of the Teradata BETWEEN … Read more »

Teradata SET operators

The SET operators in Teradata manipulate the result sets of two or more queries by combining the results of each individual query into a single result set. Most common SET operators are as below- Operator Description UNION Combines the result … Read more »

Teradata Logical Operators

Below are the logical operators which are used in Teradata. Operator Meaning = Equal to <>  Not Equal to >  Greater than <  Less than > = Greater than or Equal to < = Less than or Equal to AND … Read more »