Solved

select statement - withou null value

Posted on 2011-02-11
3
273 Views
Last Modified: 2012-06-22
I have a table which contain 73 fields. I don't want to get any fileds that has null value. How could I query it?

select *from table1 where field1 in not null, etc. One at a time?  Is there a better way?
0
Comment
Question by:VBdotnet2005
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
Rick earned 125 total points
ID: 34875810
select * from table
where field1 is not null
     and field2 is not null
     and field3 is not null

No better way.
0
 

Author Comment

by:VBdotnet2005
ID: 34875918
ok. Is there a way to get field(73) just header in one shot?
0
 

Author Comment

by:VBdotnet2005
ID: 34875933
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question