Forum Discussion
mckelvin21
Jul 29, 2021Copper Contributor
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
- olafhelperBronze ContributorPlease post table design as DDL, some sample data as DML statement and the expected result.