sql 用别名作为查询条件

select * from (select id as ID,name as NAME  from table ) a where ID='123'