How To Select Only Non -Empty Columns in a SQL Table?

Accepted answer

While I think this will be a nasty query.

What you can do is that you will only need to check the columns that have Is_Nullable set to true.

All other columns should be included because null are not allowed. This will help to reduce the number of checks required.

+1

Rafnas T P8y ago

hi,

try following query

select * from tablname where columnName is not null and columnName !=""

0

Packiaraj Santhiyagu8y ago

Hi,

Please use isnull keyword in select column.

select isnull(firstname, 'NoValue') from yourtablename

+1

Yogesh Ghorpade8y ago

Please Cast That Coulmn As Is Null And Then Use For Example

Select * from Table where Isnull(Col1,'')<>''

+1

Kalyani Shevale8y ago

Below Query use

Select * from Emp where name IS NOT NULL

+1

Chandan Kumar8y ago

I have to select only Non-Empty Column out of 100 Columns in a table the the colkumn which are Empty Should Not Be Display. while select row for a particular user

+1

Adeeb Arangodan8y ago

Hi Chandan Kumar, you can use ‘IS NOT NULL’ in WHERE clause to achieve the same SELECT * FROM tableName WHERE colName IS NOT NULL

+1

Adeeb Arangodan8y ago

Select * From Where IS NOT NULL

0