Hi all,
Below are my dataset from my simple select statement:
select count(position) as CNT, Balls, Position, Players
from Soccerdatabase
CNT BALLS POSITION PLAYERS
2 A Middle Blue
5 C front Red
1 E Middle Yellow
4 F Middle Purple
6 K front Orange
3 B Middle Brown
1 G front Green
How do I update above query so users can display the report with a parameter to select POSITION for more than 2, 3 or 4, etc?
For example: A user just want to see a report where the POSITION is "Middle" and the count is more than 2? Or POSITION is "front" and the count is more than 1?
Anyone?