--Oracle: DECLARE n_count int; begin Select count(*) into n_count from from M_Test where ENTITYLSH = 1; dbms_output.put_line(n_count); end; --sql server: declare @is_exist_alert3 int; Select @is_exist_alert3=count(*) from M_Test where ENTITYLSH = 1;
Select A,B,C from Tb1 –查询所有 Select A,replace(B,’1’,’壹’),C from Tb1 替换查询 Tb1 A B C AA1 1 CC AA2 2 CC AA3 3 CC 有什么方法 同时 把1替换为壹 把 2替换贰,把3替换叁 select CASE B ' THEN '壹' ' THEN '贰' ELSE '其他' END from Tb1 as c1, 'abc' as c2 , '' as c3 from Tb1 --虚拟列