方法1:
isnull(字段名称,0) as 字段名称
--字符型 select isnull(mycol,'0') as newid from mytable --整型 select isnull(mycol,0) as newid from mytable
方法2:
columnName为字段名
case when columnName is null then 0 else columnName end
例如:
SELECT tt.start_date,
tt.start_hour,
tt.start_minute,
tt.team_num,
tt.count,
tt.team_num_pk,
CASE
WHEN tt.countpk IS NULL THEN 0
ELSE tt.countpk
END
FROM (SELECT start_date,
start_hour,
start_minute,
team_num,
(SELECT Sum(count) AS count
FROM t_world_cup_guess_transaction_m t
WHERE t.team_num = c.team_num
AND t.match_num = c.match_num) AS count,
team_num_pk,
(SELECT Sum(count) AS count
FROM t_world_cup_guess_transaction_m t
WHERE t.team_num = c.team_num_pk
AND t.match_num = c.match_num) AS countpk
FROM t_world_cup_guess_competition_process c) tt