How to return empty row sql

How to return empty row sql

IF EXISTS ( select * from @tbl_OtherDeductionEarning)
BEGIN
    select * from @tbl_OtherDeductionEarning
END
ELSE
  SELECT 'Nil' as name, 0 as amount
end

2020-02-20

Tag