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

Home -> Community -> Usenet -> c.d.o.server -> SQL help

SQL help

From: H. John C. Hopkins <john_spam_free_at_hpe.ufl.edu>
Date: 1997/10/28
Message-ID: <6357rv$oes@no-names.nerdc.ufl.edu>#1/1 







Table VISITS


Fields  ID, DATE, RANK



ID is not a primary key (i.e., can have multiple occurrences of ID, each
with different dates and ranks)



Need to select id AND date where highest rank value.



Thanks so much for your input.



-John
Received on Tue Oct 28 1997 - 00:00:00 CST












Original text of this message













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