Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?
A .
B .
C .
D .
Answer: D
Latest C2090-320 Dumps Valid Version with 123 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund