PROBLEM while running a query with != condition

Question

0.00/5 (No votes)

See more:

sql query with != condition not working
my query is

SQL

Select regno from member_master where parentregnoM=2 and parentPosM=1 and registerAS  != 'Free'

not giving me any result
but when i write the query like

SQL

Select regno from member_master where parentregnoM=2 and parentPosM=1

show me right result
where in registerAS field values are null so first query also shows the results

Posted 30-Dec-12 18:42pm

Miss Maheshwari

Add a Solution

Comments

dimpledevani 31-Dec-12 1:02am

use <> in sql for checking 'not equal to'

ridoy 31-Dec-12 1:15am

I try with your queries in my case,it works fine whether it is != or <> because both are valid in sql,but i think your registerAS column of your database may be null which may cause this problem,and look below Mika Wendelius gave you a solution on that case..

Amir Mahfoozi 6-Jan-13 2:08am

Please tell us what the registerAS data type is?

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-12-30T19:10:00

Solution 3

If the column RegisterAs is null, you could try the following

SQL

SELECT regno 
FROM   member_master 
WHERE  parentregnoM = 2 
AND    parentPosM   = 1 
AND    (   registerAS  != 'Free'
       OR  registerAS  IS NULL)

Posted 30-Dec-12 19:10pm

Wendelius

Comments

ridoy 31-Dec-12 1:16am

+5

Wendelius 31-Dec-12 1:29am

Thanks :-D

__TR__ 31-Dec-12 4:54am

5ed!

Wendelius 2-Jan-13 3:35am

Thanks :)

FranklinRemo · Answer 2 · 2012-12-30T19:26:00

Solution 4

Hi ,

try the below one

SQL

SELECT regno
FROM   member_master WHERE  parentregnoM = 2 AND    parentPosM   = 1
AND    (   registerAS  != 'Free'
       OR  registerAS  IS NULL)

Posted 30-Dec-12 19:26pm

FranklinRemo

Aarti Meswania · Answer 3 · 2012-12-30T18:51:00

Solution 1

instead of !=
use... <>
Happy Coding!
:)

Posted 30-Dec-12 18:51pm

Aarti Meswania

Comments

Miss Maheshwari 31-Dec-12 0:54am

already tried both <> and !=

Aarti Meswania 31-Dec-12 0:58am

you mean to say it's still giving records which registerAs value is 'free' ?

Miss Maheshwari 31-Dec-12 1:02am

Select regno from member_master where parentregnoM=2 and parentPosM=1 and registerAS != 'Free'
or
Select regno from member_master where parentregnoM=2 and parentPosM=1 and registerAS <> 'Free'

not giving any result/record
but when i write query like

Select regno from member_master where parentregnoM=2 and parentPosM=1
showing me result

Aarti Meswania 31-Dec-12 1:04am

can you paste some output records?

Hemant Singh Rautela · Answer 4 · 2012-12-30T19:04:00

Just use this

SQL

Select regno from member_master where parentregnoM=2 and parentPosM=1 and (registerAS  != 'Free')

or

SQL

Select regno from member_master where parentregnoM=2 and parentPosM=1 and (registerAS  <> 'Free')

Use () for your query... != , <> both are same...

Accept The Solution if you find it works for you so that it helps others also...

Thanks
Developers Blog[^]
Hemant Singh Rautela

PROBLEM while running a query with != condition

4 solutions

Solution 3

Solution 4

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us