How to compare a value with real time query every time

Yes, it is possible.  However, as noted, a DB Table Checkpoint is not what you want in this case.

Best suggestion is to write your own SQL code in TestComplete script code to execute the desired query and compare the results to your stored expected values.

One of two ways to do so:

1) Write ADO code to connect to your database and run the query.  You can find the starting details at https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/databases/ado-requirements.html for what's available in TestComplete but you will need to research additional information on the Microsoft online documentaiton.

2) I have a script extension that I wrote that does simplify query execution somewhat.  You can find it in the link in my signature.  If you need help implementing that, let me know.