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
MySQL
5 lines
264 B
MySQL
5 years ago
|
/*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');
|