As you are aware, the job of aggregate functions is to summarize column data values stored in rows. For example, totals of a column, minimum/maximum value in a range of values, total number of rows present in a column etc. These aggregates are divided into two groups i.e. Math and Statistical. SUM, AVG, MIN, MAX, [...]

Popularity: 33% [?]

The Explain Command in Teradata provides an English explanation of the steps that the AMP (Access Module Processor) goes through while running a SQL query. As you know it is the job of Parsing Engine (PE) to create the steps for accessing the data. When the ‘EXPLAIN’ command is submitted with any SQL statement, the [...]

Popularity: 18% [?]

If you want to import data to a table in Teradata environment, BTEQ utility can help you here. There are a couple of ways you can import data using BTEQ. One way is to logon to BTEQ environment and type the import commands one after another. The other way is to put everything in a [...]

Popularity: 21% [?]

Suppose you have a big list of values and they are in a chronological order than in that case it would be easier to provide a range of values than typing in the whole list. At this place the operator ’BETWEEN AND’ comes into picture.  If you have character values which are similar in nature, [...]

Popularity: 29% [?]

As mentioned earlier while you want to limit the rows with the usage of ‘WHERE’ clause at the same time you can also use the IN operator to have multiple values in the ‘WHERE’ clause. This is an alternative use of having multiple OR. Here is the syntax.
SELECT {*|<Col1>}, <Col2>, <Col3>…
FROM <table name>
WHERE <column name> [...]

Popularity: 20% [?]

Like many other Structured Query Languages, to a very large extent, Teradata SQL is also ANSI compatible and also there are extensions available for the same. Let’s start with some basic operators we use in our day to day query building.
As you know the SELECT statement returns all the rows of a table and it [...]

Popularity: 21% [?]

As mentioned before, BTEQ is quite powerful tool if you know how to use it. One of such good feature is the usage of the import and export command. If you want to export your data to a file, follow the steps; 
First set the export file
.export data file= c:\mypath\myoutputfile\output.txt;
You can also write the following for [...]

Popularity: 21% [?]

If you are using Teradata SQL Assistant and want to import data into the Teradata environment, you would glad to know that there is a Import Utility available for it. How to use this import utility? Simply, follow the step by step instructions below.
Situation – For example you have a list of “account numbers” on [...]

Popularity: 36% [?]

SELECT statement is the most used keyword in any SQL language. Using it intelligently saves a lot of time and memory usage. The basic full syntax for the SELECT statement in Teradata SQL goes like this;
SELECT [ALL][TOP {integer | decimal} [PERCENT][WITH TIES]]
{*[.ALL]}
FROM [joined_table [RIGHT] JOIN joined_table ON search condition]
[FULL] [CROSS JOIN]
[(subquery) [AS] derived_tablename [(column name [...]

Popularity: 98% [?]

To run a very long SQL query put it in a file and run the file from the BTEQ command prompt as follows
.run file=filename path (i.e. c:\mypath\mysubpath\myfirstBTEQ.txt;
To set/change default database for the session;
Database <database name>;
To display all the default BTEQ settings
show control;
To show object (table, view etc) definition or create object statement
show <table/view/index/procedure/trigger>       ;
To [...]

Popularity: 20% [?]