to get column names which has null value from table

skam · New User Joined: 31 Jul 2006 Posts: 1

hi,
Pls help me to ,write a query to select the column name which has null value from a table
regards

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

Skam,

Hope the below query will work

DavidatK · Posted: Tue Aug 01, 2006 1:38 am

Can you explain your requirement in more detail for us? Do you want to select the row data where a specific column name is null, or do you want to select the 'column_name' for any column that is null in a row, or select the column_name for any column that is null in the table, or do you want to select column_names for columns that could be null?

Please come back

Dave

chiranjeevi_mca · New User Joined: 19 Feb 2006 Posts: 27

Select * from table where COL1 IS NULL;

the above query will retrieve the rows for col1 is null