qq_37628382的博客

select count(case when b.schedule = ‘0’ then ‘男’ else null end), count(case when b.schedule = ‘1’ then ‘女’else null end) from wsbs_apply b...

select tu.*,tb.id,tb.biddername,nvl2(tu.username, tu.enterprisename, tb.biddername) as username,tb.price,to_char(tb.pricedate, ‘yyyy-mm-dd hh24:mi:ss’) pricedatefrom trans_bidder tbleft join tr...