I have a subquery but it's returning more than 1 row. I only want the latest date available.
See below AND DATE = MAX DATE ONLY)
can anyone help?
from (select student_id
where registered = 'Y' AND DATE = MAX DATE ONLY) reg,
where st = reg.student_id(+)