SELECT * FROM ( SELECT * FROM table ) ttt
SqlServer对select * from (select *from table) 支持
原文:https://www.cnblogs.com/m0488/p/13109693.html