Last post Nov 16, 2012 10:06 PM by Lannie
Nov 16, 2012 08:43 AM|-_-|LINK
how can i get the max date but i don't want to use max function to group data
and join other table , but i don't know why i always dulipate data after joining table.
SELECT * FROM DD D LEFT OUTER JOIN
(SELECT * FROM DATETABLE WHERE NAME='B' AND ID='1' AND ROWNUM=1 ORDER BY SAVE_DATE DESC ) T ON D.ID=T.ID
I DON'T KNOW WHY I CAN'T RETRIEVE THE MAX SAVE_DATE WHEN ID=1
Nov 16, 2012 10:06 PM|Lannie|LINK
show table col names for DD and DATETABLE
show desired output col names for your query
When NAME = 'B' and ID = '1' is more than one date possible??
do not know the nature of your data
then we can help you better