The day when most of employees were Hired
This Code show The day when most of employees were Hired:-
and This code show their Names :-
SELECT hire_date,
Count(hire_date)
FROM employees
GROUP BY hire_date
HAVING Count(hire_date) = (SELECT Max(Count(hire_date))
FROM employees
GROUP BY hire_date)
/
and This code show their Names :-
SELECT first_name
||' '
||last_name "Employee Name"
FROM employees
WHERE (hire_date) = (SELECT hire_date
FROM employees
GROUP BY hire_date
HAVING Count(hire_date) = (SELECT Max(Count(hire_date))
FROM employees
GROUP BY hire_date))
/
Posts
0 comments:
Post a Comment