Help With a Decode

Group,

I searched through the archives and there seems to be a solution to my problem, but no one ever states what it is. I'm confident from what I've read that this should work, but it tells me that the select statement is not a single-group group function. Help?

SELECT decode(nvl(MAX(created), 1), 1, (select sysdate-3 from dual), MAX(created)) from audit;

Thanks,

Melih Onvural Received on Mon Jun 27 2005 - 14:49:39 CDT