kolaf
asked on
Analytic Functions min/max date employees, department
I need to get the List every Department name and (if it has any employees present) its youngest
employee (full name) and eldest employee (full name) .
EMPLOYEE
========
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
EMAIL
PHONE_NUMBER
HIRE_DATE
MANAGER_ID
DEPARTMENT_ID
DEPARTMENTS
============
DEPARTMENT_ID
DEPARTMENT_NAME
Many Thx in adv
employee (full name) and eldest employee (full name) .
EMPLOYEE
========
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
PHONE_NUMBER
HIRE_DATE
MANAGER_ID
DEPARTMENT_ID
DEPARTMENTS
============
DEPARTMENT_ID
DEPARTMENT_NAME
Many Thx in adv
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
why only a B? If you needed additional help, I'd have been glad to provide further assistance.
Please don't accept answers prematurely then assign penalty grades without giving the volunteers (not just me) a chance to complete the answer if necessary.
Please don't accept answers prematurely then assign penalty grades without giving the volunteers (not just me) a chance to complete the answer if necessary.
ASKER
Hi sdstuber
I apologise if you feel insulted. The answer was perfect for my requirements. I had no other solution
to compare it with. Can the solution be upgraded to A?
I apologise if you feel insulted. The answer was perfect for my requirements. I had no other solution
to compare it with. Can the solution be upgraded to A?
It's not so much a matter of insulting as much as leaving something unfinished.
The standard grade should be an A, with B's and C's indicating increasing levels of incompleteness or error.
"perfect for my requirements" sounds like an A.
Yes it can be upgraded. You simply click on the "request attention" link at the top of this question's page. Since you've indicated you wish to change the grade, I'll enter it for you.
The standard grade should be an A, with B's and C's indicating increasing levels of incompleteness or error.
"perfect for my requirements" sounds like an A.
Yes it can be upgraded. You simply click on the "request attention" link at the top of this question's page. Since you've indicated you wish to change the grade, I'll enter it for you.
You can also use the "request attention" link to reopen a question so you can do splits or rearrange points or otherwise change preexisting grades and point awards.
ASKER
Thanks for update on procedures
2. Should we assume your output is like the following?
Department name, Full name of youngest employee, Full name of eldest employee
IF yes, how about those department with more than one youngest/eldest employees?
3. Is "Full name" First name + <space> + Last name?