帮忙,该如何解决

帮忙

SQL code

str = "select *,ROW_NUMBER() over(order by TimeST) ROWID from"+TName3[i];                    str += "select * from " + TName3[i] + " where ROWID between 0 and 200";

SQL code

str = "select *, ROWID=identity(int,1,1) into # from"+TName3[i]+"order by order by TimeST;"                    str += " select * from # where ROWID between 0 and 200";
[解决办法]
多打了个 order by
SQL code
str = "select *, ROWID=identity(int,1,1) into # from"+TName3[i]+" order by TimeST;"                    str += " select * from # where ROWID between 0 and 200";