Display all records of employees who work in the Finance department: SELECT emp_id, emp_name, salary, dept_id FROM employee join department ON dept_id=dept_id WHERE dept_name=\'Finance\'; SELECT emp_id, emp_name, salary, dept_id FROM employee depart ment WHERE employee.dept_id=department.dept_id AND WHERE dept_name=\'Finance\'; SELECT emp_id, emp_name, salary, dept_id FROM employee AND department WHERE employee.dept_id=department.dept_id AND dept_name=\'Finance\'; SELECT emp_id, emp_name, salary, employee.dept_id FROM employee join department ON employee.dept_id=department.dept_id WHERE dept_n ...
Purchase document to see full attachment