Question

求教sql查询，当查询结果有为空的时候则该字段为空，如何实现？

即select date from table where id > 5当查询到date中有空值的时候则date为空

Answer 1

select isnull(date,'') from table where id>5

Answer 2

select
case when exists(select 1 from table where id > 5 and date is null ) then null else date end date from table where id > 5