如何运行此查询，不显示空列 [英] how run this query,dont display null column

问题描述

你好所有

i有一个包含5列的表，有3列可用数据，2列有空值

i想用可用数据列执行查询，但不应显示空值列。

hallo to all
i have a table with 5 columns, 3 columns with data available , 2 columns with null values
i want to execute a query with the available data columns, but should not display the null value columns.

推荐答案

尝试从myTable中选择* myColumn IS NOT NULL

SELECT Col1, Col2, .........
FROM Table1
WHERE Col3 IS NOT NULL
AND Col4 IS NOT NULL

select top 10 * membertable 
where col71 is not null and col72 is not null and col73 is not null and col74 is not null and col75 is not null and
 col76 is not null and col77 is not null and col78 is not null and col79 is not null and col80 is not null and
 col81 is not null and col82 is not null and col83 is not null and col84 is not null and col85 is not null and
  col86 is not null and col87 is not null and col88 is not null and col89 is not null and col90 is not null and
   col91 is not null and col92 is not null and col93 is not null and col94 is not null and col95 is not null and
   col96 is not null and col97 is not null and col98 is not null and col99 is not null and col100 is not null

但它显示所有columns.how以更改查询？

but it display all columns.how to change query?

这篇关于如何运行此查询，不显示空列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！