Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL: find all latest value = 'X'
Select R.personid, R.ratingdate
From rating_table R
Where R.rating = 'A'
And R.ratingdate = (select max(rating_date) From rating_table RT Where RT.person_id = R.personid)
--BradD Received on Wed Oct 22 1997 - 00:00:00 CDT