Horizontal Presentation - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.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