查询记录解决思路

查询记录现有一个表共5列idvarchar50namevarchar50sexvarchar50agevarchar50gradevarchar50都可以为空,现

查询记录
现有一个表
共5列
id         varchar   50  
name     varchar   50  
sex       varchar   50
age       varchar   50
grade   varchar   50
都可以为空,现在要查询出表终任意两列不为空的记录。请问该怎么作啊?谢谢

[解决办法]
--try

create table T(id varchar(50), name varchar(50), sex varchar(50), age varchar(50), grade varchar(50))

select * from T
where
(
(case when id is not null then 1 else 0 end)+
(case when name is not null then 1 else 0 end)+
(case when sex is not null then 1 else 0 end)+
(case when age is not null then 1 else 0 end)+
(case when grade is not null then 1 else 0 end)
)> 1