当做一个函数的时候提示没有足够的值的时候，该怎么办呢？

Question

create or replace function get_sjbb(tyears varchar2,tnonth varchar2)return varchar2 as v_sql1 varchar2(4000); -- 返回字符串，你这里符合条件的是SQL语句beginSELECT COUNT(DECODE(TO_CHAR(RECIEVE_DATE, 'DD'), '01', 0)) as "1", COUNT(DECODE(TO_CHAR(RECIEVE_DATE, 'DD'), '02', 0)) as "2" into v_sql1FROM V_SJBB where TO_CHAR(RECIEVE_DATE,'YYYY') = tyears AND TO_CHAR(RECIEVE_DATE,'MM') = tnonth;return v_sql1;end;

Answer 1

UPLOAD.OrderBy(x => x.SER_NO).Where((x, index) => index <= 1).Select((x, index) => new { x, index }).OrderByDescending(x => x.index);