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 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 »
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 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 »
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 »
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 »
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 »
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 »
In the select statement generally, we have seen selecting the different columns from a table. As a result of the select statement, the output is generated and the first line of the resultset is the column names that we have … Read more »
The HAVING Clause is generally used along with the GROUP BY clause to apply more filters on the result-set. Teradata HAVING example The following SQL statement list the number of employee in each department. Only include those departments with more … Read more »