select only columns which do not contain zero
i have a table with around 20 columns of data.
How do i do a query to select only the columns which do not contain 0 ?
Thanks in advance!
SELECT * FROM tablename WHERE columnname != 0
But SELECT * will show all columns.
Maybe this will be clearer:
I want to do a query to find columns which do not contain 0's
Only these columns will appear in the results, the columns which contain all zeros will not be displayed.
Last edited by mr_newbie; 02-19-2010 at 09:53 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)