Show one field if it is greater than the other....

[fenneraj]

Hi all,

Having real trouble with this one....

I have a table with a record ID (adID), advert text (ad), Submit date (sub_d) and update date (up_d). What I want to output is the ID, the ad text and ONE date. This date must be the 'newest' of the submit date and update date.

This date then needs to be sorted on so the last submitted or updated record is shown at the top.

Thanks in advance for any help provided...

Andy

 

[micha123]

select adID, ad,
       case when sub_d >= up_d then sub_d else up_d end as Dt
from table1
order by Dt desc

"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.

 

[fenneraj]

Cheers micha123,

Works a treat