如果把:select top 10 * from demo where id not in (select top 300 id from demo order by id) order by id改为:select first 10 * from demo where id not in (select first 300 id from demo order by id) order by id但,informix不支持在嵌套select中用first!!!
如果你用的是JDBC2的话可以用ResultSet的absolute方法 来定位游标的位置。
select top 10 * from demo where id not in (select top 300 id from demo order by id) order by id 不行吗??
Statement stmt=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//创建可随即滚动的SQL语句 ResultSet resut=stmt.executeQuery(....); result.last(); int rowCount = result.getRow();//行数 RecordSetMetaData rsmd=connection.getMetaData(); int colCount=rsmd.getColumnCount();//列数 result.absolute(xxx);//将游标移动到第xxx行
来定位游标的位置。
不行吗??
ResultSet resut=stmt.executeQuery(....);
result.last();
int rowCount = result.getRow();//行数
RecordSetMetaData rsmd=connection.getMetaData();
int colCount=rsmd.getColumnCount();//列数
result.absolute(xxx);//将游标移动到第xxx行