Re: SQL command for value comparison

On Fri, 12 Jan 2001 Patricia_Leong(at)tecsg(dot)com(dot)sg wrote:

> I would like to compare 2 attributes before display the result using SQL command
>
> e.g new_due_date old_due_date result to display
> -----------------------------------------------------------
> 11 Feb 2001 15 Feb 2001 in
> 12 Feb 2001 08 Feb 2001 out
>
> "select decode((new_due_date<old_due_date),'in','out') from XYZ" will not be
> working as decode only compare exact value.

Try this:

SELECT new_due_date, old_due_date, CASE WHEN new_due_date < old_due_date
THEN 'in' ELSE 'out' END FROM XYZ;
--
Tod McQuillin