Suppress repeating values I have a table that has columns like following. Batch number is a database design thing like row number

demand_id        batch_number    debit status     customer
     34               1             yes
     34               2                             jack 
     35               1             no                
     35               2                             kate 


OUTPUT:

demand_id        batch_number    debit status     customer
     34               1             yes
                      2                             jack 
     35               1             no                
                      2                             kate
Here, I have tried and tested it and it gives the output you wanted (this was tested in Oracle):

SELECT
    CASE
        WHEN dr &lt;&gt; 1 THEN NULL
        ELSE demand_ind
    END demand_ind,
    batch_number,
    debit_status,
    customer
FROM (
SELECT
    demand_ind,
    batch_number,
    debit_status,
    customer,
    ROW_NUMBER() OVER(PARTITION BY demand_ind ORDER BY rowid) AS dr
FROM test2
) test3;