The following statement can be used to select the name and job title of every employee in Department 100. In this statement, the predicate dept_no=100 is the conditional expression.
SELECT name, jobtitle FROM employee WHERE dept_no = 100;
The following statement can be used to select the name and job title of every employee in Department 100. In this statement, the predicate dept_no=100 is the conditional expression.
SELECT name, jobtitle FROM employee WHERE dept_no = 100;