例如:想要查询person表中前10项
string commandtext = "select top 10 * from person“;
对查询结果进行排序:(默认为升序排列,通过workid排序)
string commandtext = "select top 18 * from person order by workid ";
如果想要进行降序排列:
string commandtext = "select top 18 * from person order by workid desc";