sql语句查出来无记录怎么设置默认值?
select ifnull(usenum,0) as num from user ;
Orcale:
select nvl(.usenum,0) as num from user ;