Hi, I have a table Employees with
employee_name
Age
In apex page I have a page item(p123_page_selector), which is a radio button. Its values are ALL and AGED.
So, when user selects 'ALL', I want to return all data from table employees.
When user selects 'AGED', I want to return all data from employees where age greater than 35.
I wrote query like below.
How to write this query without using 'UNION'?