decode or case statements

From: "Priya, Nagappan (N(dot))" <npriya5(at)ford(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: decode or case statements
Date: 2003-03-06 09:53:53
Message-ID: 4F3E93DA9F76D6118A2A0002B330C40C040B7ECC@ap1sgm01.singapore.ford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
Please help me in forming a select statement using decode functionality or case in oracle and sql seperately.

The scenario is if a field has some value like 999999 then we had to select 0 for all the through out the table .
Please give ur answersRegards
Priya.N

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-03-06 11:32:26 sql question regarding count(*)
Previous Message Aspire Something 2003-03-06 06:00:34 Arrays Or Loop