Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL: find all latest value = 'X'

Re: SQL: find all latest value = 'X'

From: Denning <btdenn_at_bellatlantic.net>
Date: 1997/10/22
Message-ID: <01bcde9a$f263fc20$91bdc897@btdenn>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US