Forum Discussion

mckelvin21's avatar
mckelvin21
Copper Contributor
Jul 29, 2021

How to use HAVING Clause

I have two tables table 1 and table 2 linked with a relationship id say customers and orders. I need to count all records from customers and all records in orders and only records from the orders table having order prices above 100, above 300, and  500. how can I write this query, showing count for 100, 300, and 500 respectively 

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Please post table design as DDL, some sample data as DML statement and the expected result.

Resources