Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: GROUP BY and ..not a group by expression
> select id, name, testdate, marks
> from students
> where (id, marks) in
> (SELECT ID, MAX(MARKS)
> FROM STUDENTS
> GROUP BY ID);
Wouldn't this return results from other dates too? though all we are
looking for is Max(marks) immaterial of date?
Received on Fri Oct 05 2007 - 09:35:39 CDT