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

Question

create or replace function get_sjbb(tyears varchar2,tnonth varchar2)
return varchar2 
as 
v_sql1 varchar2(4000); -- 返回字符串，你这里符合条件的是SQL语句
begin
SELECT 
COUNT(DECODE(TO_CHAR(RECIEVE_DATE, 'DD'), '01', 0)) as "1", 
COUNT(DECODE(TO_CHAR(RECIEVE_DATE, 'DD'), '02', 0)) as "2" into v_sql1
FROM 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);