Deleting Duplicated Data - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

The BTEQ SUPPRESS command deletes duplicated data by replacing all consecutively repeating values with space characters in the output reports.

Example – SUPPRESS

Without using the SUPPRESS command, for example, the following SELECT statement produces the example report shown below:

select deptno, name from employee
where deptno in (100, 300) 
order by deptno;

Example report:

DeptNo  Name
------  -----------
   100  Chin M
   100  Greene W
   100  Moffit H
   100  Peterson J
   300  Russell S
   300  Phan A

Adding a BTEQ SUPPRESS command produces the example report shown below:

.SET SUPPRESS ON 1
select deptno, name from employee
where deptno in (100, 300) 
order by deptno;

Example report:

DeptNo  Name
------  -----------
   100  Chin M
        Greene W
        Moffit H
        Peterson J
   300  Russell S
        Phan A
        Leidner P

Eliminating the duplicated department numbers in the first column makes it easier to see the break between Dept. 100 and Dept. 300.