WITH DELETED ROWS Examples - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

Example: Obtain the Total Number of Rows in the Table

    SELECT WITH DELETED ROWS COUNT(*) FROM  ldi_table;

Example: Obtain the Number of Logically Deleted Rows

For information on the TD_ROWLOADID expression, see Inserting into Load Isolated Tables.

    SELECT WITH DELETED ROWS COUNT(*) FROM ldi_table
    WHERE TD_ROWLOADID > '100000000'xi8;

Example: Obtain the Number of Logically Deleted Rows From a Load Operation

For information on the TD_ROWLOADID expression, see Inserting into Load Isolated Tables.

    SELECT WITH DELETED ROWS COUNT(*) FROM  ldi_table 
    WHERE (TD_ROWLOADID/'100000000'xi8)(int) =  load_id_value;