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 -> SQL Query to get Max (Date)

SQL Query to get Max (Date)

From: Mike Haig <zzz_at_postmaster.co.uk>
Date: 7 Feb 2002 03:35:21 -0800
Message-ID: <ea1237b2.0202070335.6194b70@posting.google.com> 





Hello, I need some help in creating a query please. I have the two tables below;	
        



Table 1:



NameField   




Table2



Namefield


Datefield


Message



I want to get this result:



Name, DateField   (the datefield of the last posted message for each name).



Can anyone help with this query?



Thanks



Tony
Received on Thu Feb 07 2002 - 05:35:21 CST












Original text of this message













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