摘要:
1.各类别客户数:SELECT t.客户级别, count(t.客户级别)FROM RMW2.IRMS4PORTAL twhere t.客户级别 in('B类','A类','D类')group by 客户级别unionSELECT'C类',count(*)FROM RMW2.IRMS4PORTAL twhere t.客户级别 in('C -规模客户','C','C类')2.各类业务客户数 SELECT t.包含业务, count(t.包含业务)FROM RMW2.IRMS4PORTA 阅读全文