具有额外WHERE和ORDER BY子句的MSSQL TOP（LIMIT）操作

$query = mysql_query(\"SELECT FLD_NAME, FLD_AGE FROM TBL_USERS WHERE FLAG=\'1\' ORDER BY FLD_AGE DESC LIMIT 0,50\");

//rows_per_page = 50;

select * from 
(select Row_Number() over ( ORDER BY FLD_AGE DESC ) as RowIndex, FLD_NAME, FLD_AGE FROM    
TBL_USERS WHERE FLAG=\'1\') as pager    Where pager.RowIndex >= 10 and pager.RowIndex < 40

SELECT TOP(50) FLD_NAME, FLD_AGE FROM TBL_USERS WHERE FLAG=\'1\' ORDER BY FLD_AGE DESC 

SELECT TOP 50 FLD_NAME,FLD_AGE
FROM TBL_USERS
WHERE FLAG=\'1\'
ORDER BY FLD_AGE DESC;