求大神写一条正则表达式或者函数用来替换字符串。内容如下图

Question

输入字符串1 得出字符串2

Answer 1

以下为C#代码，已测试通过：

string pattern = @"(select[\s]+[\S]+)[\s]+(from[\s\S]+)[\s]+(order[\s\S]*)";
Regex regex = new Regex(pattern, RegexOptions.None);
string source = @"select * from jx_mingxi1 where id>0 order by id";
string target = @"select * from ($1, ROW_NUMBER()over($3) as num $2) as t where t.num>=@start and t.num<=@end";
return regex.Replace(source, target);