Online Documentation for SQL Manager for Oracle
Adding a new group
Since we also need to get the list of IT specialists (i.e. those registered in a department and having an IT-oriented job), we can add a complex filter condition combining simple conditions with the AND operator. (However, in this particular case we can just add them on the same root level as for the existing condition).
If you need to add a group of conditions, click the ellipsis button for the HIRE_DATE condition and select the Add Group popup menu item.
See also: |