Add or modify the primary index of the table in Teradata using alter table query
Initially the table might be created without Primary index or Unique primary index. Later we wants to add the primary
Continue readingCategory: Teradata
How to check the table definition or view definition of table in Teradata
SHOW Table : Some time we want to check the table definition such as number of columns ,data type of
Continue readingHow to create a view for a table in Teradata
View creation in Teradata: View is a logical table that shows the result set of SQL statements. It is used
Continue readingSelect few sample records from a Teradata table using Sample function
Sample function in Teradata The Sample function is used in the SELECT query to return the random number of rows.It
Continue readingHow to check the table size using query in Teradata
Table size in Teradata: DBC.ALLSPACE is the system table used to find the space occupied for each table or database
Continue readingSelect number of records from a table using TOP function in Teradata
Some time we wants to fetch sample rows from the table. If we use SELECT * in the query,it will
Continue readingTeradata XMLAGG function with examples
XMLAGG function: The XMLAGG function is used to perform an aggregate of multiple rows. This can used for multiple purpose
Continue readingCreate the table from another table using create table as select in Teradata
Teradata provides the option to copy the existing table structure and create the new table.We can either copy the table
Continue readingFind date difference between consecutive rows in Teradata
Calculate date difference between consecutive rows Sometime we will get the requirement to calculate the date difference for consecutive rows
Continue readingTeradata create table syntax with examples
We can create SET/MULTISET tables in Teradata. There are few differences between SET and MULTISET tables.Let’s discuss about syntax to
Continue reading