09-Having

Having Keyword

1. Using HAVING with GROUP BY and aggregate functions (AVG, SUM, COUNT, STDDEV, APERCENTILE, SPREAD, LAST)

2. Performing TOP, BOTTOM, and LAST operations on results

3. Applying ORDER BY and LIMIT OFFSET to results

4. Performing calculations and comparisons in the HAVING clause

5. Using HAVING with JOIN operations

6. Using HAVING with different types of window functions (sliding, session, event, count, state)

path: cases/09-DataQuerying/09-Having/test_query_having.py

Having bug TS-4806

test event_windows + case when + having query fix

path: cases/09-DataQuerying/09-Having/test_query_having_bugs.py

Having bug TD-31880

test last_row(ts) query fix

path: cases/09-DataQuerying/09-Having/test_query_having_bugs.py

Having bug TD-31966

test percentile() from window query fix

path: cases/09-DataQuerying/09-Having/test_query_having_bugs.py

Having bug TD-32059

test having with interval and fill

path: cases/09-DataQuerying/09-Having/test_query_having_bugs.py