oracle plsql 统计
set serveroutput on DECLARE cursor cemp is select to_char(hiredate,'yyyy') from emp ; phiredate varchar2(8); count80 number :=0; count81 number:=0; count82 number:=0; count87 number:=0; begin open cemp; loop fetch cemp into phiredate; exit when cemp%notfound; if phiredate='1980' then count80:=count80+1; elsif phiredate='1981' then count81:=count81+1; elsif phiredate='1982'then count82:=count82+1; else count87:=count87+1; end if; end loop; close cemp; dbms_output.put_line('总数据:'||(count80+count81+count82+count87)); dbms_output.put_line('1980:'||count80); dbms_output.put_line('1981:'||count81); dbms_output.put_line('1982:'||count82); dbms_output.put_line('1987:'||count87); end; /
无为而治
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步