You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

5 lines
264 B
SQL

/*28. Write a query in SQL to display the first and last name and date of joining of
the employees who is either Sales Representative or Sales Man.*/
SELECT first_name, last_name, hire_date
FROM employees
WHERE job_id IN ('SA_REP', 'SA_MAN');