use greatest function sql to get a later date.
i have about 4 date fields in my table.
i need to get the latest date of the four fields.
then find the later of the four columns with the date field values.
so for id 11 it could be col2
id2 it is column 4 and so on.
how ca i do this in oracle.
i dont know about the greatest function.
i looked into it but my work did not compile.
thanks in adv
Last edited by jmodic; 04-19-2006 at 05:16 PM.
Well, GREATEST is the function you want. And now you know about it
Originally Posted by tiffianypeck
Click Here to Expand Forum to Full Width