Report Output | Horizontal Presentation | Basic Teradata Query - Horizontal Presentation - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

By default, BTEQ presents each row of output data as one row in the reports, with each column presented side by side in a horizontal format.

For example, use the following SELECT statement:

SELECT DeptNo, Name, JobTitle, Salary
FROM Employee WHERE DeptNo = 300;

The above example produces the following report:

DeptNo   Name          JobTitle         Salary 
------   ------------  ------------  ---------
   300   Russell S     President     65,000.00  
   300   Phan A        Vice Pres     55,000.00
   300   Leidner P     Secretary     23,000.00