Forum Discussion

Raj48's avatar
New Contributor
3 years ago

Compare two SQL query results data



Is there any way to compare two SQL queries data in TestComplete through Database checkpoint? 

For ex:

SQL query 1 - DBTable1

SQL query 2 - DBTable 2

and then compare --> DBTable1 vs DBTable2


As i understand, DBCheckpoint will fetch and compare the results against base data. Not sure how to keep base data from SQL query 2 and compare it with SQL Query 1. 


Please suggest. 


Tried File Checkpoint already (by exporting the data from both the queries into different sheets and compare). Just want to know, if DBCheckpoint can help here. 

2 Replies