# \#agate-table

**URL:** https://discourse.getdbt.com/tag/agate-table/44.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [Data compare in IF condition in dbt model](https://discourse.getdbt.com/t/data-compare-in-if-condition-in-dbt-model/4767)

<div class="topic-metadata">

**Author:** [@Bhrat123](https://discourse.getdbt.com/u/Bhrat123)\
**Replies:** 2\
**Last updated:** [September 4, 2022, 7:50pm UTC](https://discourse.getdbt.com/t/data-compare-in-if-condition-in-dbt-model/4767 "2022-09-04T19:50:40Z")

</div>

I have to compare the result of query with hardcoded integer value in if condition {%- set query %} select cast(1 as integer) {% endset -%} {%- set main = run\_query(query) -%} {% if execute %} {% if main \> 2 %} G…