SQL SERVER2005后版本可以使用Rownumber函数,用作排序非常方便,配合共用表达式,更方便,例如
with c as ( SELECT Id,StartPort,StartCityCode,ROW_NUMBER() over(order by id) num FROM FlightFD)select * from C where num < 100