The Teradata SAMPLE function returns some specific amount of data from a table or view. It can be used when a smaller or more manageable data is desirable than the entire set of data from the table. Teradata Sample Function … Read more »
The Between operator in Teradata can be used to filter the result-set for the date type columns as well. The date column can have dates in various formats. Teradata Between DATE syntax The general syntax for Teradata Between date is … Read more »
Teradata DATE format function converts the default date format as per the user requirements. For ANSI date format, by default Teradata follows DATE format as ‘YYYY-MM-DD’ and for IntegerDate Teradata follows date format as ‘YY/MM/DD’. The DATE format function can … Read more »
Date and time function one of the most important function in Teradata. So we need to understand the concept very clearly. Keywords related to the Date and Time SELECT DATE AS “DATE” ,CURRENT_DATE AS “ANSI DATE” ,TIME AS “TIME” ,CURRENT_TIME … Read more »
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 »
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 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 »