select a.* from (select * from b) a
select * from (select * from 表名) as bb
你是说子查询吧select B.id from (select * from A where id<200) B取个别名就行了
