Im getting problems with trying to retrieve the maximum date value from a table
SELECT
STUDENT_NO,
MAX(START_DATE)
START_DATE
FROM MyTABLE
GROUP
BY STUDENT_NO
ORDER
BY STUDENT_NO
The result table is shown below as you can see there are duplicate STUDENT_NO for 123, why is this?
View Complete Post