row difference validation

Copper Contributor


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

@Tejay410 , I can't query images / screeshots.

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