SELECT * FROM tb200707_rhj ORDER BY f_bmbm,f_xssr DESC
trySelect * From ( Select TOP 100 * From tb200707_rhj Where f_bmbm = '1001' Order By f_xssr Desc) A Union All Select * From ( Select TOP 50 * From tb200707_rhj Where f_bmbm = '1002' Order By f_xssr Desc) B
Select TOP 100 * From tb200707_rhj Where f_bmbm = '1001' Order By f_xssr Desc) A
Union All
Select * From (
Select TOP 50 * From tb200707_rhj Where f_bmbm = '1002' Order By f_xssr Desc) B
第一行的 try 没什么用处吧!