Forum Discussion

Tejay410's avatar
Tejay410
Copper Contributor
Jul 18, 2023

row difference validation

I have above table name as reservation. now i need to validate if difference is  DifferentalrCost (D) column is correct. As you can see i can validate manual but how can i do in large scale. basically, column D represent the difference between column C rows.  Is there any way I can validate as true statement. Can someone help me with quarry.   

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jul 19, 2023

    Tejay410 , I can't query images / screeshots.

    Please post table design as DDL, some sample data as DML statement and the expected result.

Resources