sql server 用order排序 提示 列名无效，但是列确实存在，谁能帮忙解答下
ThinkPHP版本： V5.1.29 LTS

Db::name('jiaxiao_area')->field('id,name')->order('sort', 'desc')->where('status',1)->select();

PDO Error Info
SQLSTATE 42S22
Driver Error Code 207
Driver Error Message [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'sort' 无效。
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 10.0][SQL Server]列名 'sort' 无效。
Error SQL SELECT T1. FROM (SELECT thinkphp., ROW_NUMBER() OVER ( ORDER BY [sort]) AS ROW_NUMBER FROM (SELECT [id],[name] FROM [jiaxiao_area] WHERE [status] = 1) AS thinkphp) AS T1