.net中sql语句的问题，爆出异常

Question

string sql = "select * from (select t.id,row_number() over(order by id desc) as num
from table t ) b where b.num >=:start and b.num <=:end";
OracleHelper.ExecuteDataTable(sql,new OracleParameter(":start",start),
new OracleParameter(":end",end));
执行时提示“主机/赋值变量名”异常

Answer 1

谢谢！我已经知道了，是不能有start和end关键字命名的变量名，感谢！