There is an employee table where characteristics of employees are recorded. Just as an example, we want a query to show female employees, employees aged 30, or both. In other words, we need the query to show records based on two criterion, however if one criteria is empty that criterion should be ignored. If this works, in case we select the age to be 30, and we leave the gender to be blank, the query will show data about employees who are aged 30, and are female, male, or no gender mentioned. On the other hand, if we select gender to be female and leave the age criterion blank, the query will show all female employee regardless of their age.
how can we make such a criterion?
how can we make such a criterion?