Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get values of more than two columns in a group by ?
How about
SELECT column1,column2... FROM arrival table WHERE (last_name,arrive_date) in
(SELECT last_name , MAX(arrive_date) FROM arrival table GROUP BY last_name )
I think this will help.
Regards, Received on Fri Jul 26 2002 - 01:46:43 CDT