Category: Teradata

How to select the NULL values in Teradata?

NULL in Teradata NULL represents missing or unknown value in the column. In other words, NULL is a place holder

Insert into statement is used to insert a record into a table in Teradata. The syntax of the insert query

Like Operator in Teradata The Like operator is used for pattern matching in Teradata. It needs to specify in the

Row_number() function in Teradata Row_number function is used to assign the sequential number to each row of the result set

REGEXP_REPLACE function in Teradata REGEXP_REPLACE is one of the regular expression function in Teradata. It is used to replace the

PIVOT in Teradata Pivot function is used for transforming rows into columns in Teradata. It allows us to aggregate and

Grant in Teradata Grant statement is used to provide the privileges (permissions) such as SELECT,INSERT,UPDATE on a table to user.

Drop a column in a table in Teradata We can use ALTER TABLE command to drop a column from an

Current Date in Teradata In Teradata, we can fetch the current date using either CURRENT_DATE or DATE in the Select

DBC Tables in Teradata – Data dictionary of Teradata Teradata stores the log of each and every SQL query data