Checking all the fields in SQL table

Question

0.00/5 (No votes)

See more:

Hello,

I've one SQL table with different fields. Now i want to check all the values whether it's null or not and select only those values which are not null. How can i do that? Some one please help me.

Thanks in advance,
Ajay

Posted 5-Jul-13 1:54am

ajaykalarickal

Add a Solution

Comments

Adarsh chauhan 5-Jul-13 7:58am

what do you mean by " i want to check all the values whether it's null or not and select only those values which are not null"
both cases are different. please clarify what you want to achieve and if possible provide your table and sample data

ajaykalarickal 5-Jul-13 9:10am

like this,

id name age
1 null null

null null 8

null sony null

the output should be like this-

1
8
sony

I hope it's more clear now.

3 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)

Adarsh chauhan · Answer 1 · 2013-07-05T02:03:00

Both are different cases.

If you want to check all the values whether it's null or not

use

SQL

select * from TableName

and if you want to check all the values which are not null.

use

select * from TableName where ColumnName is not null

But i don't think that you want to ask this, as even a beginner in sql knows the how to use is null and is not null in where clause.

so please clarify what you want to achieve and provide sample table, data and your goal.

ajaykalarickal · Answer 2 · 2013-07-05T02:08:00

Solution 3

like this,

id name age
1 null null

null null 8

null sony null

the output should be like this-

1
8
sony

I hope it's more clear now.

Posted 5-Jul-13 2:08am

ajaykalarickal

**Nirav Prabtani** · Answer 3 · 2013-07-05T01:58:00

Solution 1

try this...:)

SQL

SELECT columnName FROM TableName WHERE columnName IS NOT NULL

Posted 5-Jul-13 1:58am

Nirav Prabtani