How to code not equal to in SQL query

Sarva_bubli · Posted: Mon Dec 04, 2006 1:17 am

Hi,
How to code not equal to in SQL query.....
May I have the explanation....

PeD · Posted: Mon Dec 04, 2006 3:38 am

Read the SQL reference manual, first.

Does this request "an explanation"?? !! Semantic?

Madhu Reddy · New User Joined: 28 Sep 2006 Posts: 56

we need to code as not equal to

for example

select * from table where column1 not equal to zero.

as query please reply

Sarva_bubli · Posted: Wed Dec 06, 2006 7:14 pm

Hi Madhu,
I got the answer. For example select Ac number from Cust table
EXEC SQL
SELECT ACCT_NO
INTO :EOP675ACCT-NO,
FROM EOP_AC_TABL
WHERE CUST_NO = XXXXXXXX
AND WIP-ID ? = 'D'
END-EXEC

Here WIP-ID not = 'D'. The not ( ? )symbol can be given as such.

Correct me if I'm wrong.

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

One more way of using NOT EQUAL is by using '<>'

Sarva_bubli · Posted: Thu Dec 07, 2006 12:02 pm

Hi MFRASHEED,
Let me try with this way also. Thanks for the info.

h.dinesh · New User Joined: 06 Dec 2006 Posts: 46 Location: Chennai

Both <> and ?= is working but 'not equal to' is not working

priyesh.agrawal · Posted: Fri Dec 08, 2006 6:17 am

DB2 V8 doesn't support "?" character, so a good idea to use "<>".

Sarva_bubli · Posted: Mon Dec 11, 2006 7:32 pm

Hi Dinesh & Priyesh,
thanks for the response..

DavidatK · Posted: Tue Dec 12, 2006 4:18 am

One additional consideration when coding not equal ?<>? is that if you are tying to compare against a null, you will not get a ?true? condition. Therefore you will need to code as follows:

Sarva_bubli · Posted: Fri Dec 15, 2006 9:42 am

Hi Dave,
Thanks for the additional info.